March 16, 2006 at 8:59 am
In SQL 2005's Object Explorer I am viewing the Stored Procedures (under Programmability). I don't see the CREATE DATE column for the procs. (this was a nice feature in SQL 2000)
Is there a way to see the various objects (Tables, Views, Procs) "CREATE DATE" in Object Explorer in 2005?
March 16, 2006 at 9:08 am
Hello Bill,
You can check up through this query
Select crdate as DateCreated
From dbo.sysobjects
where name = 'your_proc_name'
This has been detailed in today's editorial
SQL 2000 to SQL 2005: Where have all the old features gone? by Boris Baliner
Lucky
March 16, 2006 at 9:55 am
thx for the suggestion .. not to sound unappreciative, but I'm aware that I can query the catalog to derive attributes for various objects (eg. DateCreated) .. but this is quite inconvenient.
Beggers can't be chooser's I guess....
February 5, 2008 at 2:17 pm
You can see date created for objects from object explorer in sql server 2005. For that Just choose "Details" option from object explorer
May 7, 2008 at 6:55 am
The "Created" column does not show the time. Is there a way to display this?
May 7, 2008 at 8:41 am
Adam Heard (5/7/2008)
The "Created" column does not show the time. Is there a way to display this?
Not possible.
SQL DBA.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply