The transaction ended in the trigger. The batch has been aborted.

Question

The transaction ended in the trigger. The batch has been aborted.

sathpon

SSC Enthusiast

Points: 163
More actions
January 4, 2009 at 6:32 pm

#155082

[font="Arial"][/font]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

we are going to need a better description than this to help you.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

Agreed,

It looks like you tried to post some sort of code into the post that ate your text. From the preview I can see:

sql server could not configure ;instance' as a distributor

so I am guessing that you are trying to do some form or replication, and it isn't working, but we definately need a lot more than this post is currently showing to help out.

Paresh Prajapati SSCertifiable Points: 7567 More actions · Answer 3

sathpon (1/4/2009)
[font="Arial"][/font]

Please check any database trigger is ebable or not?

_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj

sathpon SSC Enthusiast Points: 163 More actions · Answer 4

Thanks for reply. my partner created trigger on the server whih is not allowing any new database creations. while configuring distributor, i guess distributor database will create on the server where distributor is located. i just removed that trigger and now it is working

thanks

sath

sathpon SSC Enthusiast Points: 163 More actions · Answer 5

Hi Prajapati

Thank you very much.

Trigger was enabled on the server which is not allowing to create Distributor Database for distributor

Thanks for suggestion.. avaluable suggestion.

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 6

Triggers are always the last place we tend to look for problems which is why their use should be documented and scrutinized before actually going into place.