Remove Transaction Notification

[Former Member]

Hi,

I've a transaction notification stored procedure, but now it causing me troubles, i need to remove, i've SQL 2000 with SP4 how i can do to remove?

[former_member201110 · Accepted solution]

Hi Jose,

If you want to restore the transaction notification stored procedure to it's original code then you can do this manually through Enterprise Manager or via a script. Obviously, you can only remove the customised part of the proc (ie where it says 'Place your code here').

Alternatively, there is a Restore Stored Procedures function built in to SBO (administrationutilitiesrestore--restore stored procedures) that will rebuild all the procs. However, you MUST get permission to run this utility from SAP support as incorrect use of this can damage your system.

Kind Regards,

Owen