Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcrowley
Aged Yak Warrior
771 Posts |
 Posted - 2004-06-22 : 16:39:04
|
| Originally posted on DBForums.com. Figured I'd give you guys a shot at it, too...Now here is a random question:I need to find all SQL Server Enterprise Edition servers on the network. Unfortunately, it appears that SMS can only check for the (non-)existence or properties of a file. It can even look for registry key values. What it apparently can not do is log into SQL Server. This eliminates @@server and serverproperty('Edition'). Anyone know of a handy-dandy way of differentiating editions of SQL Server by just looking at the filesystem or registry? Remember, SQL Server is unavailable to you.Oh, and "Ask the DBA" was apparently rejected as an answer. Darned Microsoft licensing lawyers... |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-06-22 : 17:18:38
|
| Hmm.You can find the version number in the registry, but not the edition.With a little work you can read out the edition from the windows event log if you have access to that. The message which is posted at the startup of the SQL Server service records the edition.Can't think of anything else at the moment... But then I don't have access to a server right now :( |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-22 : 18:00:40
|
| I searched and searched in the registry but couldn't find it. I think the version number is only stored as well.Tara |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-06-23 : 02:15:40
|
| The version number should be under HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLServer/MSSQLServer/CurrentVersion/CSDVersion.However, on one of my servers it shows 8.00.760 instead of 8.00.878. Strange... |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-06-23 : 02:20:07
|
| This is what the event in event viewer looks like:Event Type: InformationEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17055Date: 2004-06-22Time: 07:41:17User: N/AComputer: SED1CD08Description:17052 :Microsoft SQL Server 2000 - 8.00.878 (Intel X86) Nov 11 2003 13:37:42 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) Data:0000: 9c 42 00 00 0a 00 00 00 #156;B......0008: 09 00 00 00 53 00 45 00 ....S.E.0010: 44 00 31 00 43 00 44 00 D.1.C.D.0018: 30 00 38 00 00 00 00 00 0.8.....0020: 00 00 .. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2004-06-23 : 09:10:13
|
| Andraax. That just may work. I will see if the SMS guys can work with the ERRORLOG solution. I rotate the logs once a month, but the rotation still leaves the @@version heading in each file. Unfortunately, they save (and delete) the eventlogs every three days around here. Bit of overkill for some servers, but I guess the DC security logs get awful big awful quick. I will let you know if this works. |
|
|
|
|
|
|
Differentiate Enterprise from Standard without log