charindex or patindex can help you find the commands and then substring can help you split them out.

I wrote a series on working with strings that might help you

http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

nchar consumes two bytes as well. Do you mean convert to varchar instead? In SS2K, above 4 or 5 char, it doesn't make sense to use char.

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.