SELECT * from sys.databases is used for find the id of database. SELECT

How to get last system shutdown time in Sql server when
restarted system?

Question Posted / gaurav.verma4210

1 Answers
9049 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is 'write-ahead log' in sql server 2000 ?

1050

Can group functions be used in the order by clause in ms sql server?

1013

How to modify an existing stored procedure in ms sql server?

1079

What is NOT NULL Constraint in sql server 2012?

1000

Why do we use non clustered index?

1083

What is it unwise to create wide clustered index keys?

1007

Explain can SSRS reports Cache results?

158

What is sqlcmd?

1051

What is the use of =,==,=== operators?

1013

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

What is Service Broker in sql server 2012?

1020

What is an sql server agent?

1064

How to check status of stored procedure in sql server?

988

Explain primary key?

966

What is collation sensitivity?

1065