Vas has a good explanation, but this can be cumbersome to setup and administer. Be sure you spend lots of time testing and build some good tools to handle the...

sqldiag might do this. It's installed with SQL Server.

You can have multiple parameters, so I'd pass each item in as one call to the stored procedure and handle that in the code. At the end, you can call...

I like Jeff's suggestion, but I might also add another job to check and be sure the first one is sitll running.

Schema bound means the view is bound to the current schema of the underlying tables and you cannot change them. But I agree with jeff, to improve performance, be sure...

If you are using ADO, there are methods to move between the result sets.

AJ's method will work fine, although you might want a check to trap errors on the chance your int value exceeds the max smallint value.

There are 3rd party products like Protegrity to help with this.

Is the role in sysusers? Are there child rows in syspermissions?

Apologies for this. I have censored the post

Good question. I'd choose the clunky approach since it's simpler (to me) and you have a loaddate. If the update fails, you could remove...

I'd have to check, but I believe that there is a 1 or 2 byte offset that is stored in each row. There might be a 1 byte placeholder at the offset...

Apologies for this. I have censored the post.

Use a semaphore or flag on each record to note that it's locked, or better yet, the FK of the user ID that actually has it locked. So retrieve a...

There might be a script to help in the scripts section as well. Not to toot my horn, but I wrote some articles, all entitled Tame Those Strings (search on...