October 19, 2005 at 2:22 am
We need to check the version of the MS SQL server installation with the MS SMS tool. I know it is possible to check it with the <select @@version>, but SMS cannot use it.
Is there a way to judge it based on certain files (.dll's, .exe's etc) if the installation is a STANDARD or ENTERPRISE version? File size? version etc?
The same we need to know for Analysys and Raporting services, too.
Any help is most welcome,
Peter
October 19, 2005 at 6:52 am
You can look at the version of Ssnetlib.dll to check the version number...example, in order to distinguish between SP3 and SP3a (both return the same value via @@version), you can distinguish these service pack installs based on the version of this dll.
In the case of SP3a, the version will be 2000.80.766.0 while in the case of SP3, it will be 2000.80.760.0
Hth
October 19, 2005 at 7:12 am
Thank you, but looking at the versions we have, for both ENTERPRISE and STANDARD edition the version of these .ddl files are 2000.80.818.0 and thus, I cannot distinguish them by this file.
Peter
October 19, 2005 at 8:16 pm
I mis-interpreted your question then - The version of the ssnetlib.dll will only tell you the service pack / hot-fix level that you are on - not the edition.
Can SMS use a batch or a cmd file ? If so, then you can use osql command in the batch/cmd file to get the edition information.
October 24, 2005 at 11:51 am
The '818' indicates that hotfix 818 was applied. I've both standard and enterprise servers just like that. Now whether hotfix 818 was applied to SP3 or SP3a is another story.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply