SQL Server Performance

new tables

Discussion in 'T-SQL Performance Tuning for Developers' started by alex, Oct 4, 2004.

  1. alex New Member

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


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

    Cheers
    Twan
  3. FrankKalis Moderator

    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
    -----------------------
  4. derrickleggett New Member

    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.
  5. Twan New Member

    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

Share This Page