why not just use:

DECLARE @test-2 BIT

EXEC @test-2 = SP_TESTLINKEDSERVER [mylinkedservername]

IF @test-2 = 0

BEGIN

PRINT 'test failed'

END

else

BEGIN

PRINT 'test succeeded'

END

First off, the nature of the indexdefrag is an index at a time...so it won't rollback anything but the one call you are making.

Although I'm guessing that, given the script...

if it happens again, try exec sp_who2 to give you an idea of what is causing the problem...there's always a reason for sql server to "hang"..and it's usually something that...

That query seems a little confusing:  If the person_info table already has an identity column, you shouldn't need to insert the id.

something like this would do it:

Declare @newinsert INT

Insert into...