February 27, 2004 at 2:17 pm
My boss asked to list all of our tables and when they were created. I can see this using enterprise manager, but I have been unable to find this anywhere in the tables. Does anyone know where I might be able to run some SQL that will supply me this information. I need the table name which I can get by
select name from sysobjects where xtype = 'U'
but I have not been able to find the date and time the table was created. Can anyone help me out?
February 27, 2004 at 2:44 pm
select name, crdate from sysobjects where xtype = 'U'
* Noel
February 28, 2004 at 1:41 am
Well is there anyway that we can get the last modified date too like if we are adding some constraints from Enterprise Manager then basically it is going to dump all the data into a temp table and drop the table and create with all the newly added constraints, however if we are adding a constraint from the Query Analyser we are still going to modify the table , so can we track the date and time of modification of the table, is there any internal audit trail maintained in SQL Server.
Prasad Bhogadi
www.inforaise.com
February 28, 2004 at 1:24 pm
I don't think so. And you don't want to use C2 auditing for this.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply