Cannot delete linked servers

[1DMF]

Hi ,

I've cocked up trying to set up linked servers, only now I can't edit the settings or delete the server ?

I've tried

sp_dropserver 'SERVERNAME', 'droplogins';

but get the following error

Could not locate entry in sysdatabases for database 'distribution'. No entry found with that name. Make sure that the name is entered correctly.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[SQLBill]

From BOL:

If you run sp_dropserver on a server that has associated remote and linked server login entries, or is configured as a replication publisher, an error message is returned.

Since you are using droplogins argument, that should take care of the 'associated remote and linked server login entries'. My question then, is the server a replication publisher?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[1DMF]

nope, it's just box standard SQL 2000, on SBS 2003.

I'm thinking of linking / replicating and was my first attempt, but it's not going well.

I just been playing with views as well as I was told this would improve performance, but it didn't it made it worse.

though i'm probably not creating the unions in the best way to suit views any how.



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts