SQL Server Performance Forum – Threads Archive
when upgradedis there a tsql or stored proc to find when was the sqlserver got upgraded from 2000 to sqlserver 2005? thanks in advance
Check your log file last modified date in Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFiles folder.
It can be checked by using xp-cmdshell command…
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
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.