>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.
If it's not broken, fix it until it is.
My Blog