Table Creation DateTime

From: Gill Soo (SooGill_at_hotmail.com1)
Date: 06/10/04 

Date: Wed, 9 Jun 2004 22:50:00 -0700

Table Creation DateTime

I am using SQL Server 2000.

1.Is there any way possible to find out who created the user table ?

2.Will the Create Date of the SQL Server user table ever be modified by any
operation? In my production system I can see a user table Create Date got
changed. I was wondering did any one dropped this table and created again or
does any of the SQL server operation does change the Create Date of the user
table.

Thank you very much for your thoughts.

-Gill

Relevant Pages

  • Re: Table Creation DateTime
    ... If you are using proper permissions in place then from the sysobjects table ... In my production system I can see a user table Create Date got ... > does any of the SQL server operation does change the Create Date of the ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.server)
  • RE: Attempt to initiate a new SQL Server operation with results pending.
    ... > Subject: Re: Attempt to initiate a new SQL Server operation ... >>>initiate a new SQL Server operation with results pending. ...
    (perl.dbi.users)
  • Re: Table Creation DateTime
    ... select crdate from sysobjects where name='table' ... > Table Creation DateTime ... > 2.Will the Create Date of the SQL Server user table ever be modified by ... > does any of the SQL server operation does change the Create Date of the ...
    (microsoft.public.sqlserver.server)
  • Re: Moving a cluster to a new SAN
    ... trying the switchover on a production system. ... I have a clustered SQL Server 2000 running on Win2K3 and SAN. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Create trigger - do users need to be out?
    ... The test trigger took just a second to create. ... there are users in the production system. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)