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.
| Author |
Topic |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-02-26 : 16:37:09
|
| Is there any to do like this:Ok, I have about 500 servers and I created the datbase with only one table to stored all the information for each server:Table Design:ServerNameOperatingSystemServerFunctionServerLocationServicePackBackupSystemModelRamProcessoretc,Is there any way for me have the automatic information from each server insert into this table? without runing each command for each server?thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-26 : 17:21:40
|
| No. |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-02-27 : 08:18:14
|
| Are you trying to automate the process ? If so, you could create a table (say servername, status ), populate it with server names, then run a cursor to get the info, write it into your table, change status to done, and get next servername. At least - off the top of my head, I think you can. Only problem is, I think (correct me if I'm wrong) that you would need all 500 servers in the linked servers for your local machine. But if you're going to admin, you may want to do that anyway (btw - what is max number of linked servers ?)Just a thought - I could be totally off-course here. |
|
|
|
|
|
|
Server Information