Viewing 15 posts - 1 through 15 (of 62 total)
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...
December 21, 2016 at 10:30 am
Thom A (12/21/2016)
This means that the login must have a user on the target database, and have permission...
December 21, 2016 at 9:53 am
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:
May 4, 2016 at 10:43 am
Great - thank you for your help.
Rachel.
February 14, 2012 at 5:18 am
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...
February 14, 2012 at 2:04 am
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,...
February 9, 2012 at 3:38 am
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...
February 9, 2012 at 2:16 am
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),...
February 7, 2012 at 9:48 am
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...
January 25, 2011 at 1:56 am
In case anyone is interested, this turned out to be a bug, and MS have made a hotfix for it.
October 22, 2010 at 4:39 am
Are you using transactional replication or merge replication? I have read that this tab is only available for transactional replication.
July 23, 2010 at 2:06 am
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...
July 22, 2010 at 1:56 am
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...
July 7, 2010 at 2:53 am
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...
July 2, 2010 at 9:42 am
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...
June 28, 2010 at 9:10 am
Viewing 15 posts - 1 through 15 (of 62 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy