The servers table. - REMEMBER THIS.

OK, for many of the functions I'm going to post in the near future, you're going to need a table that contains the names of all the servers you're administering. I would suggest this, for now. (If it changes in the future, I'll bring this post back up again.)

create table SQLServers (
  sname nvarchar(128) not null, -- the server name
  ipaddr nvarchar(15) null, -- the server's IP address
  adminusr nvarchar(30) null, -- the admin user name, like 'sa' or 'dba'
  rouser nvarchar(30) null -- a 'read only' user
)

More later.

-D.