Keeping a save point while cleaning up the database

Hi All,

I am interacting with Toad for SQL for the first time. I have worked on PLSQL developer and I have to clean up my database. For doing that activity I have to keep savepoints which in PLSQL we can do by the following syntax: “SAVEPOINT savpoint_name”. Please anyone can help me in knowing the syntax in “Toad for SQL Server 5.8” for savepoint and rollback.

Hi,

Is the 'save transaction ’ will help you? Detail please see below.

msdn.microsoft.com/…/ms188378.aspx

Best Regards,

Kelly