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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2013-10-18 : 08:58:51
|
| I'm trying to drop a linked server in SQL Server 2000, however I get the following error message:Error 911: Could not locate entry in sysdatabases for database 'distribution. No entry found with that name. Make sure that the name is entered correctly.I don't understand why I'm getting this message. There is no replication or distribution on the local or remote server.Is there a setting I need to change? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-18 : 09:03:32
|
quote:
Originally posted by ranvir_2k
I'm trying to drop a linked server in SQL Server 2000, however I get the following error message:Error 911: Could not locate entry in sysdatabases for database 'distribution. No entry found with that name. Make sure that the name is entered correctly.I don't understand why I'm getting this message. There is no replication or distribution on the local or remote server.Is there a setting I need to change?
That seems to suggest that you are either using an incorrect or invalid name. Try exec sp_helpserver and see what that shows. |
 |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2013-10-18 : 09:25:45
|
| It's fine now, I've resolved the issue now.Thanks. |
|
|
|
|
|
|
Unable to drop linked server