Re: Table Creation DateTime
From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 06/10/04
- Next message: Yiannis Patrikaidis: "Re: Cnot start SQL Server 2000sp3"
- Previous message: Dinesh T.K: "Re: Table Creation DateTime"
- In reply to: Gill Soo: "Table Creation DateTime"
- Next in thread: Uri Dimant: "Re: Table Creation DateTime"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 11:42:53 +0530
> 1.Is there any way possible to find out who created the user table ?
If you are using proper permissions in place then from the sysobjects table
you can query something like:
Select User_name(uid), name from sysobjects
and get user who created the same. If the user is a system admin then the
user name will be dbo.
> 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.
The crdate in the sysobjects will hold the creation date. This WILLNOT
change unless the object was dropped and recreated. This is the only option.
The only value that changes on modification is the base_schema_ver value.
Hence if you have a snapshot of the table with these two columns you can
find out which are modified and which tables are re-created.
-- HTH, Vinod Kumar MCSE, DBA, MCAD, MCSD http://www.extremeexperts.com Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp "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 > >
- Next message: Yiannis Patrikaidis: "Re: Cnot start SQL Server 2000sp3"
- Previous message: Dinesh T.K: "Re: Table Creation DateTime"
- In reply to: Gill Soo: "Table Creation DateTime"
- Next in thread: Uri Dimant: "Re: Table Creation DateTime"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
