September 10, 2008 at 2:42 pm
I have a development server, built before I got here. It appears master was restored from another server which had several linked servers. I cannot see them all in Enterprise Manager but they are definitely in master.sysservers I cannot create a new linked server with servers that are already in the table. I cannot access the linked servers via QA that are in the table and that I do not see in EM. I also know I shouldn't be deleting from system tables. How do I go about correcting this or is this going to involve rebuilding master? Google hasn't yielding anything yet (I've only looked at 100 or so out of 383,000 hits!). Any pointers would be most appreciated.
-- You can't be late until you show up.
September 10, 2008 at 3:39 pm
Have you tried dropping linked servers using sp_droplinkedserver stored procedure?
MJ
September 11, 2008 at 12:50 pm
Thanks Manu! Sometimes the obvious proves elusive. In the words of the immortal Homer Simpson - "DOH"! sp_dropserver did the trick. :blush:
-- You can't be late until you show up.
September 11, 2008 at 1:33 pm
FYI - Upon further investigation of the servers and interrogation of the former DBA, I found out these were remote servers created several years ago. They're history now!
-- You can't be late until you show up.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply