>>Hi all
>>
>>Keeping in mind that we have no DBA
>>
>>When I change userid from mine to the generic that I want to use, I run into the happy circumstance where table inserts/updates/etc do not happen. The procedure runs perfectly under my ID, but nothing happens (and no error generated) under the generic ID.
>>
>>The connection happens just fine. Just nothing else.
>>
>>What do y'all need to see to tell me what I'm missing?
>>
>>Thanks
>
>Start from running SQL Server Profiler, looking at the command you're sending to SQL Server and then try to execute the same commands using the same generic userid from SSMS.
>
>Also, apparently your code can not properly determine this error condition and somehow eats the error. You may want to trace this part of the code also.
Been there, done that - works just fine, command looks good - no error generated
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place