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 characters needed characters left characters exceeded

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

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

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.