----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Sanjay_Narang Message 7 in Discussion Here is answer to above two questions 1. osql command giving error: The command you are giving will work for default instance of SQL server, but NetSDK is named instance, so give the server name like this: "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe" -S "<machine_name>\netsdk" -E -Q "USE master SELECT @@version" 2. Two different versions: The second one (@@ersion) is correct, I'm not sure what sp_server_info is giving. Generally we should refer to this table for SP. The latest SP is 3a only SQL Server 2000 @@VERSION ProductLevel SQL Server 2000 8.00.194 RTM Database Components SP1 / Desktop Engine SP1 8.00.384 SP1 Database Components SP2 /Desktop Engine SP2 8.00.534 SP2 Database Components SP3/SP3a /Desktop Engine SP3/SP3a 8.00.760 SP3 As version is same for SP3 and SP3a, to check that we need to know the version of this dll: C:\Program Files\Microsoft SQL Server\Binn\Ssnetlib.dllOR C:\Program Files\Microsoft SQL Server\MSSQL$<instance_name>\Binn\Ssnetlib.dll If the version number of this file is 2000.80.760.0, you have SP3; if the version number of this file is 2000.80.766.0, you have SP3a. For more information, you can see this http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
