Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction.
in [Programming SQL]
|
Prev: SQL2005 Import
Next: HELP! "could not complete cursor operation because the set options have changed since the cursor was declared"
From: RSH on 21 Apr 2006 10:40 Hi, I am trying to execute a simple statemnt that I got right out of books online and I keep getting this error and I cant figure out what Im doing wrong: ALTER DATABASE [00057088] SET SINGLE_USER WITH ROLLBACK IMMEDIATE Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction. Thanks! Ron
From: RSH on 21 Apr 2006 11:21 I just noticed something odd...this command works on our Test Server but not on our production server. The production server is a 64 bit SQL Server 2005 instance while the test is a 32 bit SQL Server 2005 instance. "RSH" <way_beyond_oops(a)yahoo.com> wrote in message news:%23r8KLGVZGHA.428(a)TK2MSFTNGP02.phx.gbl... > Hi, > > > > I am trying to execute a simple statemnt that I got right out of books > online and I keep getting this error and I cant figure out what Im doing > wrong: > > > > ALTER DATABASE [00057088] > > SET SINGLE_USER > > WITH ROLLBACK IMMEDIATE > > > > Msg 226, Level 16, State 6, Line 4 > > ALTER DATABASE statement not allowed within multi-statement transaction. > > > > Thanks! > > Ron > >
From: RSH on 21 Apr 2006 11:51 Or is it a difference in Standard vs. Enterprise? "RSH" <way_beyond_oops(a)yahoo.com> wrote in message news:uykc6cVZGHA.4760(a)TK2MSFTNGP03.phx.gbl... >I just noticed something odd...this command works on our Test Server but >not on our production server. The production server is a 64 bit SQL Server >2005 instance while the test is a 32 bit SQL Server 2005 instance. > > > "RSH" <way_beyond_oops(a)yahoo.com> wrote in message > news:%23r8KLGVZGHA.428(a)TK2MSFTNGP02.phx.gbl... >> Hi, >> >> >> >> I am trying to execute a simple statemnt that I got right out of books >> online and I keep getting this error and I cant figure out what Im doing >> wrong: >> >> >> >> ALTER DATABASE [00057088] >> >> SET SINGLE_USER >> >> WITH ROLLBACK IMMEDIATE >> >> >> >> Msg 226, Level 16, State 6, Line 4 >> >> ALTER DATABASE statement not allowed within multi-statement transaction. >> >> >> >> Thanks! >> >> Ron >> >> > >
From: Tibor Karaszi on 21 Apr 2006 15:03
Perhaps someone configured the server to set implicit transactions to on. That can be done in the client, or at the server level (sp_configure, user options). -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "RSH" <way_beyond_oops(a)yahoo.com> wrote in message news:e1eOutVZGHA.4920(a)TK2MSFTNGP02.phx.gbl... > Or is it a difference in Standard vs. Enterprise? > > > "RSH" <way_beyond_oops(a)yahoo.com> wrote in message news:uykc6cVZGHA.4760(a)TK2MSFTNGP03.phx.gbl... >>I just noticed something odd...this command works on our Test Server but not on our production >>server. The production server is a 64 bit SQL Server 2005 instance while the test is a 32 bit SQL >>Server 2005 instance. >> >> >> "RSH" <way_beyond_oops(a)yahoo.com> wrote in message news:%23r8KLGVZGHA.428(a)TK2MSFTNGP02.phx.gbl... >>> Hi, >>> >>> >>> >>> I am trying to execute a simple statemnt that I got right out of books online and I keep getting >>> this error and I cant figure out what Im doing wrong: >>> >>> >>> >>> ALTER DATABASE [00057088] >>> >>> SET SINGLE_USER >>> >>> WITH ROLLBACK IMMEDIATE >>> >>> >>> >>> Msg 226, Level 16, State 6, Line 4 >>> >>> ALTER DATABASE statement not allowed within multi-statement transaction. >>> >>> >>> >>> Thanks! >>> >>> Ron >>> >>> >> >> > > |