Aaaargh! :crying:

It was because I was doing execute as user instead of execute as login!

All that remains now is to see if I can set up a SQL Server Agent...

Thom A (12/21/2016)

---

If you're using an SP that is cross database, permissions are not inherited.

This means that the login must have a user on the target database, and have permission...

Big Data is my pet hate - people mostly have no idea what it means, and then use it when they only mean Rather Large Data! :w00t:

Great - thank you for your help.

Rachel.

All of the code is in T-SQL stored procedures - it's the cross-server work that I use SSIS for.

All of the servers are SQL Server, and I initially thought I'd...

Yes, thanks.

I have it all working nicely now - not worth the trauma of MSDTC.

The only thing which could go wrong would be if the commit at one server succeeded,...

I guess nobody knows the answer then - I have now officially given up!

I am instead going to use Execute SQL tasks with begin tran/commit tran and rollback in an...

Have you checked that this is the only error you're getting?

I've discovered that it's quite common to get this error AFTER you've had a real SQL error (e.g. constraint violation),...

I think that in our case it might have been a problem with people getting locked out of their windows accounts half way through the day.

Hence it was working, and...

In case anyone is interested, this turned out to be a bug, and MS have made a hotfix for it.

Are you using transactional replication or merge replication? I have read that this tab is only available for transactional replication.

In Management Studio, right-click on the Replication folder and choose Launch Replication Monitor. In the Replication Monitor, coose the pulication you're interested in and you'll see the Tracer Tokens...

What a stupid question! I straigtaway thought that the syntax was wrong, and assumed it was just a mistake.

I guess I should have known that if it was a...

I'm at a complete loss as to what's going on. I fixed the view on Monday, and set my weekly index rebuild to try again on Monday night, and...

The plot thickens...

I fixed the problem in our live database. I then took a backup and restored it as a different database. When I looked at the restored...