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

How do I open port 1433?

0 Answers  


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,


What is a Join in SQL Server?

3 Answers  


Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,


What is enhanced database mirroring in sql server 2008?

0 Answers  


How to convert binary strings into integers in ms sql server?

0 Answers  


Wht is Stuff in sql ser

2 Answers  


How to install sql server 2005 express edition?

0 Answers  


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  


What do you do in data exploration

0 Answers   EXL,


What is a cursor, index in sql?

0 Answers  


Do you know what are different types of replication in sql server?

0 Answers  


Categories