This is a great idea! I have downloaded and run both SQL scripts. Now when I try to do a DROP TABLE I get this error:
[font="Courier New"]ErrorNumber: 102
ErrorMessage: Incorrect syntax near '-'.[/font]
In the Messages box it says:
[font="Courier New"]
Caution: Changing any part of an object name could break scripts and stored procedures.
(1 row(s) affected)
The transaction is in an uncommittable state. Rolling back transaction.
The object dbo.[[mytablename]] has been moved to the recycle bin
as object zz_RecycleBin.dbo_$_[[mytablename]]_$_[[my username]]_$_2009_05_27T13_41_14_933[/font]
However, the table has not been dropped. And SP_UNDROP says:
[font="Courier New"]There are no objects in the recycle bin[/font]
This is on SQL Server 2005 (9.0.4035). What could I do to try solving this?