I was trying to
get last server start time through DMV sys.dm_os_sys_info on all sql servers
instance where groups was 2005+2008+2008r2+2012+2014. I got the result quickly
excluded from one sql server 2005 instance it populated error..
Msg 207, Level 16, State 1, Line 1
Invalid column name
'sqlserver_start_time'.
I think Microsoft
was forgot to add this column in 2005. I managed it through.
SELECT crdate FROM sysdatabases WHERE
[name] = 'tempdb'.
and
xp_readerrorlog
Apart from this SYSDATETIME() was
also not present in 2005 but now this is available …
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757