TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Debarshi Sengupta
NA
4
0
Trigger not firing in SQL Server 2000
Sep 6 2009 1:40 AM
Hi All,
I have created a Insert Trigger and a Update Trigger on a table in a database in SQL Server 2000. The Insert trigger will make an insert into another table whenever an insert happens on the table on which trigger is created.
Now an external application (developed in .NET and I have no source code access) makes an insert successfully in the table. But the trigger doesn't fire.
When I directly execute a insert script on the table from SQL Query Analyzer, then the trigger fires but when insert is done by the external application (.NET app) the trigger doesn't fire.
Can somebody help me out with this...I'm completely clueless as to why it is behaving this way.
Thanks
Debsoft
Reply
Answers (
2
)
DataGrid WPF
C# Database value, assembly and other errors. Please Help.