SQL Server Try Catch Transastion
You want to do the BEGIN TRANSACTION prior to the BEGIN TRY:

BEGIN TRANSACTION 
BEGIN TRY
    DELETE FROM dbo.LocalSummeryRealTable;
    INSERT INTO dbo.LocalSummeryRealTable
    SELECT S.*
    FROM  #LocalSummery' AS S;
    COMMIT TRANSACTION;
END TRY
BEGIN CATCH
       IF @@TRANCOUNT &gt; 0 ROLLBACK TRANSACTION; 
END CATCH


Also, please schema-qualify references to database objects such as tables, views, stored procedures etc.  Also, you should get in the habit of adding semi-colons to the end of each statement.

SET XACT_ABORT ON; is not necessary if you are explicitly rolling back the transaction inside the CATCH block.