new tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

new tables

Hello, guys.
How can I truck down the new tables being created in db?

you could run sql profiler, or select from sysobjects looking for anything with a crdate later than the date you want Cheers
Just note that this crdate won’t change when a modification is done via an ALTER statement. It will only change when DROPped and CREATEd. In case you also thought of this… ———————–

We hired a guy to stand by the SQL Server. You have to sign his clipboard before he lets you put anything new on the server. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
that would of course be the SQL server that is not connected to the network for security reasons <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />Cheers<br />Twan