开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜