How do I get the creation date of a Table.

Question

Post reply

How do I get the creation date of a Table.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

select name, crdate from sysobjects where xtype = 'U'

* Noel

Prasad Bhogadi SSCrazy Eights Points: 9235 More actions · Answer 2

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

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]