August 3, 2004 at 9:45 am
How do I know which service pack and version of MSDE is running on a computer. I just installed the sp3 on it and it still says the same version under the client network utility (8.00.194). The only difference I see after the upgrade from sp2 are the versions of the library file name under the Network Library tab. How can I determine which version I have now?
TIA
August 3, 2004 at 9:54 am
open up query analyzer and run the query
select @@version
make sure you run it with the output to text (not grid) and you'll see your version number
MVDBA
August 3, 2004 at 10:51 am
I don't want to the know the version of the Server, I want to know the version and srv pack of the client network utility.
August 4, 2004 at 7:15 am
Hi Newbie... check .dll version in C:\winnt\system32
odbcbcp.dll
2000.81.9031.14 2002/11/15 (SP3)
2000.81.9031.29 2003/02/10 (SP3 with fix ODBC)
2000.81.9031.38 2003/03/11 (SP3a)
OR
sqlsrv32.dll
2000.81.9031.14 2002/11/15 (SP3)
2000.81.9031.29 2003/02/10 (SP3 with fix ODBC)
2000.81.9031.38 2003/03/11 (SP3a)
regards
Nilton
Nilton Pinheiro
August 4, 2004 at 3:03 pm
Hi, Elsa. You are looking for C:\WINDOWS\SYSTEM32\cliconfig.exe. When you find it, check the Version tab on the properties. That will tell you the version and most other info about the utility that you need.
Regards,
Don
August 16, 2004 at 4:56 am
by the way I install SP3a and when i run
select @@version
(in Query Analyzer) I get this output : Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Note: this Service Pack 3 is for windows not SQL Server
and when i check odbcbcp.dll or sqlsrv32.dll
I get the version : 2000.81.9042.0
and when i check cliconfig.exe
I get the version : 2000.85.1014.0
and under the client network utility, i get (8.00.194)
does anyone can help us and told us what these numbers are ? and where we can find SP3a ?
thanks for anyone who reply
Alamir Mohamed
Alamir_mohamed@yahoo.com
August 16, 2004 at 5:12 am
you can find sql server service pack 3a on http://www.micorosft.com/sql
service pack 3 and service pack 3a both report the version of
8.00.760
although 3a includes the SQL slammer protection. Both of these report back as service pack 3 (not 3a)
MVDBA
August 16, 2004 at 6:45 am
by the way, what "a" is stand for in SP3a ?
Alamir Mohamed
Alamir_mohamed@yahoo.com
August 16, 2004 at 6:49 am
it's just the next revision number (like 3.1)
MVDBA
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply