Yes
Nobody knows everything, but everybody knows something
Search This Blog
Thursday, August 4, 2011
Query to Check the SQL Server Restart time
SELECT
Dateadd
(
s
,
(
(
-
1
)
*
(
osd
.
[ms_ticks]
/
1000
)
),
Getdate
())
AS
serverrestartdatetime
,
osd
.
sqlserver_start_time
FROM
sys
.
[dm_os_sys_info] osd
;
OR
SELECT
name
,
crdate
FROM
sys
.
sysdatabases
WHERE
name
=
'tempdb'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment