I receive similar error from time to time.

I solve problem by

dropping all publicatins and disabling publication and distribution and then recreating these all.

I do not do a restore of...

I am against OPENROWSET/OPENDATASOURCE. If you change something in your topology (network name,database name,login/password) it is a nightmare to change your code. Also, it is least secure method,...

This is OK for general reporting, but when you want to get online data..., you need to use link server.

Also, do not forget that using data from source you receive...

Can you make a synonym for database?

If not mistaking, you can use sysonyms for objects in database. So, you can choose between use of them(for most db objects) and views(for...

Hi all,

Nice discussion.

I was implementing similar solution so want to share my experience.

Link server should be created by functionality. After creating a SQL link server, change its physical name...

I guess, you will need 36+'' monitor to see it ;-).

There is a good practise to check execution plan...

I did the same. I wrote sql sp and added it as SQL JOB to log into table all lockings/blockings holding more than some criteria(logging blocking/locked required resource,type...

Nice. I agree with others, you should use "with recompile" statement . And more, if you are using MS SQL 2k5, you may use...