SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

BEGIN TRANSACTION;

SELECT [PK]
FROM [SageDumbAssTable]
ORDER BY [PK] DESC;

-- do your updates....

ROLLBACK;

declare @currentNextOptionId decimal(19,0) = (select NXOPTID from [linked server].[sage db].[dbo].[GXOPT]);

    protected override void OnExecute(object parameter)
    {
        const int showIntelliSenseId = 2531;
        using (var commandBars = _vbe.CommandBars)
        {
            using (var command = commandBars.FindControl(showIntelliSenseId))
            using (HookVbaBeep())
            {
                command.Execute();
                _pumper.PumpMessages();
            }
        }
    }

    private LocalHook HookVbaBeep()
    {
        var processAddress = LocalHook.GetProcAddress(_vbeApi.DllName, "rtcBeep");
        var callbackDelegate = new VbaBeepDelegate(VbaBeepCallback);
        var hook = LocalHook.Create(processAddress, callbackDelegate, null);
        hook.ThreadACL.SetInclusiveACL(new[] {0});
        return hook;
    }