you don't have to go through the registry for that - look up the SERVERPROPERTY() function in Books Online. You can find a lot of information about the server using that function.
If for some reason you still need the registry, everything SQL Server stores is in this base hive:
HKLM\Software\Microsoft\MSSqlserver\
|||
in query analyzer type: SELECT @.@.VERSION
or try HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
also see
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/50660f9ebffa92c8/c132c39beb51c4c2?lnk=st&q=how+to+find+sql+server+2000+version+in+registry&rnum=1&hl=en#c132c39beb51c4c2
Microsoft Knowledge Base Article – 321185
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#3
Hope this helps
dscastro
No comments:
Post a Comment