Viewing 8 posts - 1 through 8 (of 8 total)
Okay, I tried using a proxy:
First I created a new credential using my user as an identity. Then I created a proxy using that credential and ticked the SQL Server...
March 4, 2009 at 10:45 am
Ed (2/9/2009)
but you might try losing the User:: and just use the variable name
also if there is a space after the comma that might be...
February 9, 2009 at 10:27 am
I've got another problem that is literally causing me to tear my hair out at the moment.
If I try and pass in more than one variable into the Script Component,...
February 9, 2009 at 10:03 am
Isn't me setting the SELECT to READ ONLY pretty much the same as setting the mode to repeatable read and would this mode be sufficient for what I want to...
October 28, 2008 at 10:57 am
SQLZ (10/28/2008)
Have you tried setting the transaction isolation level?
SET TRANSACTION ISOLATION LEVEL SERIALIZABLEDo this inside the body of the stored proc, before you declare the cursor.
I did read that section...
October 28, 2008 at 10:07 am
Never mind.
Did a FOR READ ONLY on the select statement and then did a normal update on the table with the ID.
If there is a beter way of doing this,...
October 28, 2008 at 9:53 am
Sorry, I must have copied something after making a change but not commiting it.
The .dll has been moved to the "C:\Program Files\Microsoft SQL Server\Mssql\Binn" directory as it says in the...
July 10, 2007 at 8:17 am
Viewing 8 posts - 1 through 8 (of 8 total)