Getting SQL versions on all servers

[JtheRipper]

Hi there,

I want to create a script to list the version of all SQL Servers on the network.

I know I can use "select @@version" to get the version of the sql server I am logged on to, and I know I can execute "exec master..xp_cmdshell 'ISQL -L'" to get a list of all sql servers on the network, but I do not know how to connect the two and create a SP to run "select @@version" on each server.

Any help/info?

Thanks,
J.

 

[jgoodman00]

This has been posted on the Newsgroups, & a suggested solution can be found here:

http://www32.brinkster.com/srisamp/sqlArticles/article_15.htm

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures