Symptom
use master
go
sp_dboption tempdb, "ddl in tran", "true"
go
use tempdb
go
checkpoint
go
if object_id("proc1") <> 0
drop proc proc1
go
create proc proc1 as
begin
create table #tab1 (col1 int)
drop table #tab1
end
go
begin tran
exec proc1
commit tran
go
Msg 277, Level 16, State 1:
Server 'myserver', Procedure 'proc1', Line 4:
There was a transaction active when exiting the stored procedure 'proc1'. The temporary table '#tab1' was dropped in this transaction either explicitly or implicitly. This transaction has been aborted to prevent database corruption.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0.
Read more...
Environment
SAP Adaptive Server Enterprise (all versions)
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview