Prev: deploying SSIS packages
Next: Multiple processes have roughly the same logintime in sysprocesses
From: Titan on 30 Jun 2008 12:53
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?
--
Thanks
Titan
From: Andrew J. Kelly on 30 Jun 2008 13:24
You can see the entire created datetime in sys.objects.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Titan" <Titan(a)discussions.microsoft.com> wrote in message
news:67CEDF6A-4B23-44B3-999B-992054091662(a)microsoft.com...
> 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?
> --
> Thanks
> Titan

From: Tibor Karaszi on 30 Jun 2008 13:45
.... and FWIW SSMS 2008 RC0 do present the time.

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


"Andrew J. Kelly" <sqlmvpnooospam(a)shadhawk.com> wrote in message
news:%23KiLzYt2IHA.5728(a)TK2MSFTNGP06.phx.gbl...
> You can see the entire created datetime in sys.objects.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Titan" <Titan(a)discussions.microsoft.com> wrote in message
> news:67CEDF6A-4B23-44B3-999B-992054091662(a)microsoft.com...
>> 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?
>> --
>> Thanks
>> Titan
>

 | 
Pages: 1
Prev: deploying SSIS packages
Next: Multiple processes have roughly the same logintime in sysprocesses