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 derrickleggett@hotmail.com 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
