Object Explorer Details

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Titan - 30 Jun 2008 17:53 GMT

In previous versions of SQL you could see the created date and time.

In SQL 2005 you only see the created date. Is there a way to see the
created time in SQL 2005?

Signature

Thanks
Titan

Reply to this Message

Andrew J. Kelly - 30 Jun 2008 18:24 GMT

You can see the entire created datetime in sys.objects.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> In previous versions of SQL you could see the created date and time.
>
> In SQL 2005 you only see the created date. Is there a way to see the
> created time in SQL 2005?

Reply to this Message

Tibor Karaszi - 30 Jun 2008 18:45 GMT

... and FWIW SSMS 2008 RC0 do present the time.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> You can see the entire created datetime in sys.objects.
>
>> In previous versions of SQL you could see the created date and time.
>>
>> In SQL 2005 you only see the created date. Is there a way to see the
>> created time in SQL 2005?

Reply to this Message