Re: Table Creation DateTime

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 11:38:08 +0530

Gill,

#1. SELECT TABLE_SCHEMA
     FROM information_schema.tables
     WHERE table_name='<table_name>'
Refer 'CREATE TABLE' in BooksOnLine for the different values which occupy
the above column.

#2. I dont think any other operation other than drop-and-create would change
the creation date. 

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Gill Soo" <SooGill@hotmail.com1> wrote in message
news:etvzC7qTEHA.3480@TK2MSFTNGP11.phx.gbl...
> 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
    ... 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)
  • Table Creation DateTime
    ... Table Creation DateTime ... 2.Will the Create Date of the SQL Server user table ever be modified by any ... 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 user ...
    (microsoft.public.sqlserver.server)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... > Dont get me wrong, I appreciate the wizards for certain, especially since ... > file where I'm suppose to register the SHAREPOINT instance of SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... It is called ACCESS DATA ... SQL Server has taken over the world. ... I still disagree with your understanding of the popularity of Access. ... I dont think that there is a single company in the nation with more ...
    (microsoft.public.excel)
  • Re: self referential database table
    ... in case a person change his name or any details we dont want to update ... I would recommend that you have a table PersonHistory that holds ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
Loading