Can trunc table statement be used in Store Proc?

[6656]

Hi all,

The truncate table command is written to a store procedure. However, bellow Error message came out.
"TRUNCATE TABLE command not allowed within multi-statement transaction."

Plz give some example to fix the erro.

bellow option was set before run my store proc.

sp_dboption mydb, "ddl in tran", true
go
used mydb
go
CHECKPOINT
goe

Thank,
Mike

 

[akenty]

I was able to truncate a table in a stored procedure using the following:

     EXECUTE IMMEDIATE
        'TRUNCATE TABLE tablename ';';