Thanks to your help the person in charge of the server will start using Sql Server backups instead of disk backups.

Thanks

I ran a test and it appears that the DTC works even against closed connections. In the code that follows I have two insert methods that open and close...

Thanks for getting back to me on this. I do have one more question if you don't mind. I have seen a few examples of using .NET TransactionScope which...

I don't seem to be able to get SSC Journeyman's method to work, but since Matt's works fine I will stick with that.

Thanks for the time and patience.

Matt's method worked perfectly. SSC Journeyman had suggested a parameter list that didn't have delimiters. That is why I didn't include them in my first attempt. Regardless of...

Maybe I did something incorrectly, but when I executed this code using Set @ParmList = '1', the resultset contained rows with status values 1 and 12. Here is the code...

I have been getting some interesting solutions to my question. I appreciate them all as I learn something from everyone one of them. Am I correct that your solution...

This was very helpful. Casting the Status field into a VarChar that was surrounded by a delimiter during the selection never occurred to me.

Thanks. I really appreciate your...

That is really cool. I never knew that you could flip the Like statement the way you did. Before I implement this I want to be sure that I understand...

Your idea seemed like an interesting idea so I thought I would give it a try just to see how it worked. When I tried to run it I...

That did the trick. Many thanks

First I would like to thank you for all your help. I really appreciate it.

I wanted to test the function so I issued the following Select Statement:

select idno

From dbo.SplitStringToInt('1|2|3')

The output...

Sorry to be a pest about this, but when I executed the function I got the following error:

Insert Failed because the following Set options have incorrect settings: 'ANSI_NULLS, ANSI_WARNINGS, ANSI_PADDING'...

Do...

I am new to this XML query stuff so please forgive the question. I have tried to get your function to complile, but I keep getting errors about an alias...

Thanks, I will give that a shot.