MSDE - Which version?

[mutley1]

Hi All,

Can anyone tell me an easy way to find out which version of MSDE a server is running. Secondly, which version of the MS03-031 patch do I apply to which? I assume MDSE 2000 is the 2000 version, and anything else would be the version 7 patch.

Mutley

 

[hmckillop]

to find out the version in QA use

select @@version

The latest release of MSDE 2000 includes the service pack SQL Server 2000 SP3a . Go to microsoft and download it rather than applying patches etc. You can find it at:

http://www.microsoft.com/sql/msde/downloads/download.asp

"I'm living so far beyond my income that we may almost be said to be living apart

 

[mutley1]

Sorry - I forgot to mention, I know I can register the servers in E Manager and run a select @@version, but there are a couple I don't know any registration details for. that's my problem!! The question on the MS03-031 still stands!

Thanks,

M.

 

[hmckillop]

As far as the MS03-031 have a look at the Microsoft site

http://www.microsoft.com/technet/security/bulletin/MS03-031.mspx

and expand the additional information tab.

To find out all the SQl server instances in the network you can use "osql -L" from a command prompt.
Then you can use "sqlping ipaddress" replaceing the ipaddress with the name of the server - this gives all details including version. SQLPING is available from

http://www.sqlsecurity.com/DesktopDefault.aspx

Hope this helps.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[mutley1]

Thanks hmckillop,

I'll give the osql a go & see what arises! Do you know if I can just run the MSDE (2000A) install on those reporting current version as SQL 7 to 'kinda upgrade'. Would be easier to keep them all up to the same version.....Sorry - i have looked round MS site but as you probably know, the question you ask rarely lists articles with a relevant answer unless it's a 2 word question....

Thanks,

M.

 

[hmckillop]

If you run the MSDE (2000A) install it will install an new instance of SQL rather than updgrade. I am not sure where or if there is an upgrade for MSDE (SQL 7) version to SQL 2000A

Have a look at this link it might help.

http://www.dovico.com/KBase/WebHelp/kbase/sql_server_version.html

If it works, can you let me know. Thanks,


"I'm living so far beyond my income that we may almost be said to be living apart

 

[mutley1]

OK - will have a read and let you know. Might want to put a mail notification on this thread as I'm not sure when i'll get my guys to provide a test server for me!

Thanks again.

M.

 

[hmckillop]

i found something else that might help you, search for SQLPing on google - i think the link is SQLSecurity.
Anyway the tool gives you a GUI interface for checking all the instances of SQL in your network and then also will give back full version information.
Hope this helps.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[mutley1]

Thanks mate - will give it a go.....much appreciated