SQL Server 2000
I've been tasked with cleaning up an SQL database of which I have no history working with so I'm not familiar with the tables within. Short from dropping a table and seeing if anyone hollers, what is the best practice for cleaning up orphan tables? I did not see a "modified date" attribute on the table, only a "created date".
Would the process be the same for SQL Server 2005/8?