Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Documentation

Author  Topic 

vdavid70
Yak Posting Veteran

67 Posts

Posted - 2005-09-09 : 05:28:14
Hi,
I need to provide a managerial report of all the servers within my organisation. The report would include server names,server configuration,version,memory,processor,ip address, netbios name etc.

Also Sql server version,language,platform,server name,cpus, server collation,authentication mode i.e weather sql server or windows authentication, users within the database and their permissions.

Now my question is that is there any stored procedure or tool i can run to get all this information.

Thanks.
   

- Advertisement -