I haven't tried this, but the doc'n for Registering Servers seems to indicate that sp_addserver does just that if executed locally, and sp_addlinkedserver would replace sp_addserver for version 7.0 and up.
If that doesn't do it, maybe the SQL-DMO RegisteredServer object would provide the solution. If all else fails, the EM server registrations are stored in the registry. On my NT4 SP6 with SQL Server 2000, it is in HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\<Group Name>. The registered server name is the value name under this key. However, the data kept for those values appears non-trivial. HTH, Tore. -----Original Message----- From: David L. Penton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 10:15 AM To: ActiveServerPages Subject: RE: SQL Server 7 - Server Registrations It sounds like he is asking for programmatically adding it through the MMC, since sp_addlinkedserver adds a linked server, not a registered server in Enterprise Manager. Chris, Please clarify what you want. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Bostrup, Tore [mailto:[EMAIL PROTECTED]] Is sp_addlinkedserver what you are looking for? HTH, Tore. -----Original Message----- From: Chris Jackson [mailto:[EMAIL PROTECTED]] Hi guys - im looking for a way to ADD a server registration to SQL Server 7.0 thru code. anyone have a pointer? thanks. --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
