Wednesday, March 21, 2012

how to find the edition of SQL Server 2000/2005 through registry?

Hey, I need to understand what version of SQL is running on some machine. How can I do it looking through the registry. I know you can do it for windows and exchange but I don't know how to do it for SQL 2000. I know in SQL 2005, it tells you the edition for SQL, but how do you do it in SQL 2000. Also, I'm pretty sure, you can look at the Product ID and tell if it's an enterprise edition or standard edition and so on, but I don't have the information. Windows and Exchange do it like that. Can someone provide me with such info? Thank you

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