1. From the DNN > Host menu, uninstall all Smith modules (Make sure you check the delete files box when you uninstall)
2. Confirm that all stored procs and tables with a prefix of "Smith" in your database are deleted
3. Confirm that all Smith folders in /DesktopModules are deleted and the folder is removed
4. Reset iis to release the cache
5. Install the latest cart module
6. Configure the Settings
7. Test to check if module is working correctly

1. From the view menu in SQL Mgmt Studio select "Object Explorer Details"
2. Select the "tables" folder
3. All the Smith tables and sprocs have a prefix of "Smith" so if you click on the table name column heading it will sort all the Smith objects together.
4. Scroll down to the first table with a prefix of "Smith" and click once on the table
5. Scroll down to the last table with a prefix of "Smith" and "shift-click".  All the tables will now be highlighted.
6. Press the delete key to delete all the tables
7. Repeat steps above for the sprocs

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'U' and name like 'smith%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'U' and name like 'smith%'
exec('drop table ' + @tempName)
set @count = @count - 1
END

DECLARE @SQL VARCHAR(1000)
DECLARE @tempName VARCHAR(1000)
DECLARE @count VARCHAR(1000)
select @count = COUNT(*) from dbo.sysobjects where type = 'p' and name like 'smith%'
while @count > 0
Begin
Select @tempName = name from dbo.sysobjects where type = 'p' and name like 'smith%'
exec('drop procedure ' + @tempName)
set @count = @count - 1
END