question

bmurali09 avatar image
bmurali09 asked

Trigger allow to stop create table

Please help me to resolve this issue. Tried to create a table in database. I found below error. **The transaction ended in the trigger. The batch has been aborted.**
triggers
10 |1200

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

1 Answer

·
Kev Riley avatar image
Kev Riley answered
You have a transaction-aborting error in your trigger, that's what you need to identify and resolve
3 comments
10 |1200

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

bmurali09 avatar image bmurali09 commented ·
Please help me, how can i find trigger and disable on my instance? I verified every database, but i can't find on trigger which i'm facing the above error.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
In SSMS, Expand 'Server Objects' and look under 'Triggers'
0 Likes 0 ·
bmurali09 avatar image bmurali09 commented ·
Thanks Riley, It's resolved and able to create a table.
0 Likes 0 ·

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.