chrhedga,

the SET NOCOUNT ON only has to do with displaying the messages of how many rows were affecting in a SQL statement. It doesn't affect whether or not a...

Thanks, momma mia.. hehe...

funny that those two names would respond..

I realize both of you said the same thing.

Unless I see something else, I'm going to

have to go with your...

mia,

yes i can check from the actual calling application.. however, then the business

rules will be outside of the stored proc which is what i'm trying to avoid.

i can't capture the...