开发者

Delete trigger is not working when fire from c# but working in sql server

开发者 https://www.devze.com 2023-01-10 12:50 出处:网络
i made a after delete trigger on a table1 and in this trigger i insert the deleted data in another table name tab2.

i made a after delete trigger on a table1 and in this trigger i insert the deleted data in another table name tab2. when i execute the delete stor开发者_JAVA百科ed procedure of table1 from sql server 2005 then trigger working fine but when i execute delete stored procedure of table1 from c# then it is not working properly. Help me


Sounds like a permissions issue to me. Check the login in your connection string. Are those the same credentials you used to sign in to Management Studio? If not, verify that the user has permission to access the trigger, as well as permission to do whatever the trigger does.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号