How to know what sql version is installed.

Hi, we are verifying the licenses of sql server that we have installed
on al the company. But we don´t know how to know with type of
installation a machine has.
For example, if i execute the select @.@.version statement in QA it
returns all the information But we need a way to know this information
at a file level.
Do you know how can i get this information without using sql sentences.
Thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Maria,
I just this week wrote this kixTart script that checks for the product
version of a local SQL client tools installation. We will be running it
through Scriptlogic which is the script running tool that we use
(recommended). Scriptlogic is a kixtart environment, but the script could
easily be made into vbscript.
The @.@.version command checks to see what is installed on the server that
hosts the database regardless of where you run it from.
$LogFile = "\\Acsb\Common\Administration\Shared\DB\inv\Cver.txt"
$SQLFile = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
$AnaLiveFile = "C:\Anasazi\Live\AS\APP\ATRAIN.ICO"
$AnaExist = "No Value"
If Exist ("$AnaLiveFile")
$AnaExist = "Y"
Else
$AnaExist = "N"
EndIf
If Exist ("$SQLFile")
$Cver = GetFileVersion("$SQLFile", "ProductVersion")
Else
$Cver = "No SQl File"
EndIf
$ReturnCode = RedirectOutput("$LogFile","0")
If $ReturnCode = 0
? @.WKSTA + "," + $Cver + "," + $AnaExist + "," + @.USERID + "," +
@.PRODUCTTYPE + "," + @.FULLNAME + "," + @.IPADDRESS0 + "," + @.DATE + "," + @.CSD
EndIf
The product version of osql.exe will be 800.760 if Service pack 3 is
installed, 800.194 if not. I hope that helps.
"MariaGuzman" wrote:
> Hi, we are verifying the licenses of sql server that we have installed
> on al the company. But we don4t know how to know with type of
> installation a machine has.
> For example, if i execute the select @.@.version statement in QA it
> returns all the information But we need a way to know this information
> at a file level.
> Do you know how can i get this information without using sql sentences.
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>