SQL Server Performance Forum – Threads Archive

new tables

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

---

you could run sql profiler, or select from sysobjects looking for anything with a crdate later than the date you want Cheers
Twan

---

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… ———————–
–Frank
http://www.insidesql.de
———————–

---

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

---

]]>