SQL Server Performance Forum – Threads Archive
when upgraded
is there a tsql or stored proc to find when was the sqlserver got upgraded from 2000 to sqlserver 2005? thanks in advanceCheck your log file last modified date in C
![Stick Out Tongue :p :p](styles/default/xenforo/smilies/tongue.png)
It can be checked by using xp-cmdshell command…
MohammedU.
Moderator
SQL-Server-Performance.com
Or if you can query the system tables in SQL 2005 – sysindexes.keys or sysdevices.size and if returns NULL then it is an upgraded database. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>