In this post i would like to show you simple tip to find when the database created.
SELECT name,crdate
FROM master..sysdatabases
Database->Date Of Creation
-------------------------------
master-> Apr 8 2003 9:13AM
tempdb-> Jan 29 2010 9:22PM
model-> Apr 8 2003 9:13AM
msdb-> Jul 9 2008 4:46PM
AdventureWorks-> Aug 31 2009 9:49AM
AdventureWorksDW-> Aug 31 2009 9:50AM
AdventureWorksLT-> Aug 31 2009 9:50AM
AdventureWorks2008-> Aug 31 2009 9:50AM
AdventureWorksDW2008-> Aug 31 2009 9:51AM
AdventureWorksLT2008-> Aug 31 2009 9:51AM
(13 row(s) affected)
Please let me know if you have any other way to find the same information...
Thursday, February 4, 2010
Find the Database creation date (DATABASE AGE) in SQL Server
Labels:
DotNetVJ,
SQL Server,
Vijaya Kadiyala
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment