question

mail2anupam.kr avatar image
mail2anupam.kr asked

Alter in Trigger statement

Can someone please help me to understand below trigger statemet- ALTER TABLE [Product].[Category] WITH CHECK ADD CONSTRAINT [FK_Product_CategoryID] FOREIGN KEY([CategoryID]) REFERENCES [Product].[CategoryList] ([CategoryID]) GO ALTER TABLE [Product].[Category] CHECK CONSTRAINT [FK_Product_CategoryID] GO When i alter the trigger to see the definition i found it has again alter table same trigger as check constraint(2nd alter statement). Is this correct. Can it cause some issues like slow/hang? my whole db is hanging and i am trying to troubleshoot the issue. Please help.
triggertablesalter-tablecheck
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
You say that the ALTER is in the trigger? What else is in the trigger? Can you show us the complete code?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.