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 |
|
suman.reddy39
Starting Member
34 Posts |
 Posted - 2008-08-05 : 06:56:56
|
| dear all, when i run a script i got this error message but i didnt get what exactly dose it mean(The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.)can you help me in this regards.....thanks in advanceDon't go the way Life takes you, Take the Life the way you gosubbi |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-05 : 08:38:40
|
quote:
Originally posted by suman.reddy39
dear all, when i run a script i got this error message but i didnt get what exactly dose it mean(The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.)can you help me in this regards.....thanks in advanceDon't go the way Life takes you, Take the Life the way you gosubbi
You didnt begin a transaction. Post the full codeMadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-05 : 13:52:49
|
quote:
Originally posted by suman.reddy39
dear all, when i run a script i got this error message but i didnt get what exactly dose it mean(The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.)can you help me in this regards.....thanks in advanceDon't go the way Life takes you, Take the Life the way you gosubbi
thats because you dont have an active open transaction to commit. Are you sure you've a BEGIN TRANSACTION statement preceding this statement in your code marking beginning of an explicit transaction? |
|
|
|
suman.reddy39
Starting Member
34 Posts |
Posted - 2008-08-07 : 04:50:01
|
| yes i have a preceding statement after this statement.Don't go the way Life takes you, Take the Life the way you gosubbi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-07 : 04:54:00
|
quote:
Originally posted by suman.reddy39
yes i have a preceding statement after this statement.Don't go the way Life takes you, Take the Life the way you gosubbi
Then this error will come if you're trying to commit it more than once |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-07 : 04:54:01
|
| Madhi already asked you to post the code you're using. do itEm |
|
|
|
|
|
|
sql related