Hi,
I am very new to this environment - I hope this is the right platform to discuss my issue:
I created a CRON job to run a Stored Procedure from our database - Sybase.
Within the Stored Procedure there is a TRUNCATE table and CREATE table function.
the CRON job fails to run with Msg 226 saying TRUNCATE not allowed within a multi-statement transaction - as well as the CREATE table...
Is there some limitation I am not aware of or is there a simple way to get around this?
thanks, Don