Query to get SQL Server Installation Date...

[toocool4school]

Hi

Is there a way I can get the date when a SQL Server database was installed ?

Thanks
Aswin

 

[philhege]

Look at the mdf's date created column in the data directory.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.

 

[toocool4school]

Thanks... But is there a way I can extract the information using a query ? Coz I need to automate the process...

 

[philhege]

EXEC sp_helpdb 'Database name'

It's the 'created' column in the first recordset.

Read BOL for more information about administrative procedures like sp_helpdb.