How can I determine MSSQL version remotely ?

Toggle sidebar Toggle sidebar
P

polm

Diamond Member
May 24, 2001
3,183
0
0
I need a way to remotely detemine the build versions of approx. 250 SQL servers. I would like to script this. I have a line by line of the machines IP addresses. Is there a way to probe a machine running SQL 2000 for the current build number ?
 
C

charrison

Lifer
Oct 13, 1999
17,033
1
81
Originally posted by: polm
I need a way to remotely detemine the build versions of approx. 250 SQL servers. I would like to script this. I have a line by line of the machines IP addresses. Is there a way to probe a machine running SQL 2000 for the current build number ?
Click to expand...

Enterprise manager might be able to do this...
 
ultimatebob

ultimatebob

Lifer
Jul 1, 2001
25,134
2,448
126
You run 250 SQL Servers?!? Ouch! The next few days are going to royally suck for you....
 
ultimatebob

ultimatebob

Lifer
Jul 1, 2001
25,134
2,448
126
I'm lucky to only have one server in my lab running SQL Server 2000. The rest are all running either SQL Server 7 or DB2.
 
P

polm

Diamond Member
May 24, 2001
3,183
0
0
Ok I am so stupid

REG QUERY = SQL version :)

BTW...we arent going all the way to SP3, just patching our SP2's . I dont trust SP3 yet.
 
MichaelD

MichaelD

Lifer
Jan 16, 2001
31,528
3
76
Related: SP3 does slow down your "Start/Shutdown/Restart" time. Sometimes, it just hangs...for two or three minutes, then it restarts.
 
P

polm

Diamond Member
May 24, 2001
3,183
0
0
Originally posted by: MichaelD
Related: SP3 does slow down your "Start/Shutdown/Restart" time. Sometimes, it just hangs...for two or three minutes, then it restarts.
Click to expand...

another good reason why I wont take these boxes to SP3 :)

But I wonder...are you talking about W2K SP3 or SQL 2K SP3 ?
 
MichaelD

MichaelD

Lifer
Jan 16, 2001
31,528
3
76
Originally posted by: polm
Originally posted by: MichaelD
Related: SP3 does slow down your "Start/Shutdown/Restart" time. Sometimes, it just hangs...for two or three minutes, then it restarts.
Click to expand...

another good reason why I wont take these boxes to SP3 :)

But I wonder...are you talking about W2K SP3 or SQL 2K SP3 ?
Click to expand...

Uh, just the plain old SP3 for W2K....the Average Joe User Download Patch...for regular Joe's like me. :)
 
C

charrison

Lifer
Oct 13, 1999
17,033
1
81
Originally posted by: MichaelD
Originally posted by: polm
Originally posted by: MichaelD
Related: SP3 does slow down your "Start/Shutdown/Restart" time. Sometimes, it just hangs...for two or three minutes, then it restarts.
Click to expand...

another good reason why I wont take these boxes to SP3 :)

But I wonder...are you talking about W2K SP3 or SQL 2K SP3 ?
Click to expand...

Uh, just the plain old SP3 for W2K....the Average Joe User Download Patch...for regular Joe's like me. :)
Click to expand...

This is an sql sp3 :)
 
You must log in or register to reply here.

TRENDING THREADS

COMPANY
RESOURCES
FOLLOW
Top Bottom