what do you mean it can see the SQL Server? You can log in? If you can log in, SP2 has nothing to do with it. It would be a...

I'd use the Apex tool or another as documentation is best done by a tool.

Just insert permissions

set identity_insert mytable on

insert mytable (myidentity, myvalue) select @myid, @myval

set identity_insert off

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