• 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?