{"id":219,"date":"2012-05-17T10:59:12","date_gmt":"2012-05-17T10:59:12","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/05\/17\/cannot-issue-save-transaction-when-there-is-no-active-transaction\/"},"modified":"2012-05-17T10:59:12","modified_gmt":"2012-05-17T10:59:12","slug":"cannot-issue-save-transaction-when-there-is-no-active-transaction","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/05\/17\/cannot-issue-save-transaction-when-there-is-no-active-transaction\/","title":{"rendered":"Cannot issue SAVE TRANSACTION when there is no active transaction."},"content":{"rendered":"<p><strong>Error Message:<\/strong><br \/>\n<font color=\"red\"><br \/>\nMsg 628, Level 16, State 0, Line 1<br \/>\nCannot issue SAVE TRANSACTION when there is no active transaction.<br \/>\n<\/font><\/p>\n<p><strong>Why This Error?<\/strong><br \/>\n&#8211; This error occurs when SAVE TRANSACTION\/TRAN command is issued prior to issuing BEGIN TRANSACTION Command.<br \/>\n&#8211; The transaction could be commited\/Rollbacked before issuing SAVE TRANSACTION command <\/p>\n<p><strong>Examples:<\/strong><br \/>\n[sql]<br \/>\nSAVE TRAN Tran1<br \/>\n[\/sql]<br \/>\nOR<br \/>\n[sql]<br \/>\nBEGIN TRAN<br \/>\nROLLBACK TRAN<br \/>\nSAVE TRAN Tran1<br \/>\n[\/sql]<\/p>\n<p><strong>Fix\/Resolution:<\/strong><\/p>\n<p>Check for BEGIN TRAN command before SAVE TRAN command.<br \/>\nCheck if the tran is commited\/rollbacked before SAVE Tran Command.<br \/>\nIf the transaction needs to be saved then make sure that the SAVE TRAN command is issued after the BEGIN TRAN command and before the COMMIT\/ROLLBACK Tran command.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error Message: Msg 628, Level 16, State 0, Line 1 Cannot issue SAVE TRANSACTION when there is no active transaction. Why This Error? &#8211; This error occurs when SAVE TRANSACTION\/TRAN command is issued prior to issuing BEGIN TRANSACTION Command. &#8211; The transaction could be commited\/Rollbacked before issuing SAVE TRANSACTION command Examples: [sql] SAVE TRAN Tran1&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2014,128],"tags":[2015,2016],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/219"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=219"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/219\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}