Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

Answer / 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

More SQL Server Interview Questions

What is trigger in salesforce?

0 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,


Data table as parameter in sql server?

0 Answers  


How to download and install microsoft .net framework version 2.0?

0 Answers  


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  


what are default? Is there a column to which a default cant be bound?

1 Answers  


can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  


What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,


Name few of the dcl commands in sql?

0 Answers  


which backup strategy you are following at ur company

0 Answers  


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,


How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,


Categories