A list of databases, version, and servername

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Richard Fryar Hall of Fame Points: 3457 More actions · Answer 1

SQL Server 2008 has the ability to send queries to multiple servers and return the results in one resultset.

Try something like this:

select serverproperty('MachineName'), serverproperty('ProductVersion'), serverproperty('Edition'), serverproperty('ProductLevel')

or this

select serverproperty('MachineName'), name

from sys.databases -- or master..sysdatabases if you need it to work with SQL Server 2000

Jason Crider SSCertifiable Points: 6019 More actions · Answer 2

I would recommend starting here[/url] and following the 2 related articles.

It will work great with what you are talking about as well as a ton of other stuff.