Clean installation of SmithCart

SmithCart > Installation
If the installation of SmithCart was unsuccessful or your Cart has gotten out of sync and you would like to start fresh, a clean installation of the module may be necessary to ensure that the module and all of its components are properly installed.
 
To delete the old module and start with a clean installation, please follow these instructions:
  1. From the DNN > Host menu, uninstall all Smith modules; Smith.BuyNow, Smith.AffliateTracking, Smith.Categories, etc. (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 Cart Settings
  7. Add one Category, Manufacturer and Product and test
 
If you have SQL Mgmt Studio its pretty easy to delete all the tables and stored procs without a script.  Steps as follows:
  1. From the view menu in SQL Mgmt Studio select "Object Explorer Details"
  2. Select the "tables" folder
  3. All the Smith Cart 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
 
You can also run the following SQL scripts to remove all smith tables and stored procedures, so you don't have to do it manually.

Remove all tables:
 
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
 

Remove all Stored Procs:
 
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