Hi Nathan,

Which version of the Cart had your site been running?

Here are some 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

Please let me know if I can help with anything else.

Thanks