How to get last system shutdown time in Sql server when
restarted system?
- 1 Answers
- 8554 Views
- I also Faced
- E-Mail Answers
Answer Posted / gaurav.verma4210
SELECT * from
sys.databases
is used for find the id of database.
SELECT create_date
FROM sys.databases
WHERE database_id = 2
Tempdb db is recreated each time SQL Server is restarted so
the created date time of TEMPDB will also give you the date
and time of the last restart of the instance.
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
How to find tables without indexes?
what are cursors? : Sql server database administration
What are filegroups in sql server?
Can an entity have two primary keys?
Explain about link server in sql server?
How do I find the port number for sql server?
What are the benefits of filtered indexes?
How do I install only the client tools of sql server 2000?
what exactly sql injuction.how to overcome.....
Explain what is the use of custom fields in report?
What are the parts of a function?
Explain database normalization?
what is create database syntax? : Sql server database administration
Differentiate between ms sql server reporting services vs crystal reports?
What are cursors and when they are useful?
