1. First Option is to check when the tempdb database is created. This is the exact time at which the services were restarted.
1. SELECT
crdate AS 'SQL Server
service started Time'
FROM master.dbo.sysdatabases
WHERE
name = 'tempdb'

exec xp_readerrorlog
2. Second Option is the information about the database startup will be available while executing the command,


kinjal patelPosted Jan 10, 2013, 11:12 PM
how to find out pro-grammatically(mfc vc++2010) server name when application is installed in your pc? plz reply my mail id : [email protected]
kinjal patelPosted Jan 10, 2013, 11:12 PM
how to find out pro-grammatically(mfc vc++2010) server name when application is installed in your pc? plz reply my mail id : [email protected]
kinjal patelPosted Jan 10, 2013, 11:11 PM
how to find out pro-grammatically(mfc vc++2010) server name when application is installed in your pc? plz reply my mail id : [email protected]
kinjal patelPosted Jan 10, 2013, 11:11 PM
how to find out pro-grammatically(mfc vc++2010) server name when application is installed in your pc? plz reply my mail id : [email protected]