Interested to Buy Any Domain ? << Click Here >> for more details...
How to get last system shutdown time in Sql server when
restarted system?
- 1 Answers
- 9147 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
Explain different types of locks in sql server.
How to create a simple table to test triggers in ms sql server?
Explain about extended stored procedure?
How to divide query output into multiple groups with the group by clause in ms sql server?
Does sql server use java?
What is mssql?
Mention the command used to rename the database.
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What are exact numeric data types in ms sql server?
List out the differences between the clustered index and non-clustered index in sql server?
What is normalization and what are the advantages of it?
What xml support does the sql server extend?
Explain timestamp datatype?
How to Insert multiple rows with a single insert statement?
What happens if an integer is too big for int date type?
