can not drop a linked server

[bdiaz]

We have a definition for a linked server, which was created using sp_addlinkedserver procedure. Now we want to drop taht definition, but when we try to use sp_dropserver procedure (BOL) we get error message 911:

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

The local server is not configured to use replication, so distribution database does not exists, can we drop this linked server definition somehow (without configuring the server to use replication) ?

We are using MS SQL Server 7.00.842

 

[JayKusch]

Can you remove it though Enterprise Manager in the Linked Servers tab under the Security tab?

Thanks

J. Kusch

 

[bdiaz]

We get the same message from EM than from QA.