For anyone else coming across this issue, here's a brilliant article explaining this...

http://www.sqlservercentral.com/articles/Security/65169/

Excellent Brian! THANKS

I have read many articles explaining exactly this, but your's tops the list by far!

Hmmm, could be a couple of things, but lets start somewhere:

Does the user at Site C have the required SQL permissions on the Databases at Site A?

Tx for the input Kshitij, however, we will be going standard ed. primarily due to the Express DB size constraints.

Aahhh, and Tommy just gave another solution 🙂

When using windows authentication and querying linked servers over 3 or more "tiers" - you need to enable a setting in AD called something like "trust SQL Server for delegation"...

We have a production server running about 10 (90) Db's with 4 (80)'s and no issues at all wrt incompatibilities

Looking at the error it seems that the conversion from a unicode column to an ANSI column is failing?

What is your destination?

Yes, very possible indeed.

To use a practical example:

an overnight job might update (flag relevant records) and move (insert to another DB/SERVER + delete existing) a considerable amount of records.

This could...

I realise this thread is a bit old, but I also came across a "suspended" status for my logreader as well as distribution agent for the first time, and since...

Thanks for all the effort with this article!

Excellent to read!

WOW! extremely usefull contribution - TX Chad!

This will save myself hours of work every month...

Hi all,

Sorry for reviving this old thread but my questions are directly related to the comments above.

With the help of all the articles and discussions I was also able to change...

It's funny how the working environment and company procedures influences the productivity and time requirements of staff...

I used to work for a company where I had only 2 databases on...

Hi Phil,

Thanks for the easy to understand advice

I tested the following configuration as per John/Phil's suggestions/advice:

Leaving the PK on the identity column with a non-clustered index.

Because the date...