Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Grifter
Constraint Violating Yak Guru
274 Posts |
 Posted - 2010-08-27 : 10:14:02
|
Hithis is in addition to another post on here but it is sort of linked to the same task. Anytime I run any procedure with the sp name it gives me the following message:Terminating this procedure. Cannot have an open transaction when this is run.This happens on any user, DB action like sp_grantlogin, sp_change_users_login etc, it keeps saying it can't run within a transaction, but what transaction, I only have one line !sp_change_users_login 'Auto-Fix', 'user-name', null, 'pw'GO What does thie error actually mean?And how can I resolve it?ThanksG |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-08-27 : 11:09:43
|
| In SSMS, if you go to Tools -> Options, then have a look at Query Execution -> SQL Server -> ANSI, have you got SET INPLICIT_TRANSACTIONS ticked? Or on the Advanced, what is your TRANSACTION ISOLATION LEVEL. |
 |
|
|
|
|
|
Open Transaction Problem