Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Thumbs up Unanswered: [2005] Who created this table?

    Is there a command I can use to find out WHO created a specific table?

    ~Le

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Short of asking your coworkers?

    If you have Lumigent's Log Explorer, you can extract some of that information (at least when the table was created) from the transaction logs or the transaction log backups.

    If you do not have the applicable transaction logs, you are pretty much reduced to trying to figure out who has rights to create tables, and asking them.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Unless it was a sandbox (so who would care anyway), I would have total control over my databases.

    I'm not too sanguin about a wild west show
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Thumbs up

    Quote Originally Posted by Brett Kaiser
    Unless it was a sandbox (so who would care anyway), I would have total control over my databases.

    I'm not too sanguin about a wild west show
    It is a sandbox, but we told our developers not to create dummy tables. So we are trying to crack down.

    So it looks like Sql Server 2005 has NO way of determining who created a table. That's too bad.

    `Le

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    For 2005 you can define DDL triggers that will fire on a create table statement. You can use them to create an audit trail.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •