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 Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFiles folder.
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.
]]>