Nonqualified transactions are being rolled back.

in what kind of circumstance and when does SQL give the above message?

thanks
LVL 6
anushahannaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
cyberkiwiConnect With a Mentor Commented:
Most commonly when you use

ALTER DATABASE ..... WITH ROLLBACK IMMEDIATE

It causes any open transactions to be rolled back.
0
 
anushahannaAuthor Commented:
OK. makes sense.. thanks Richard.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.