begin try	  
			set @rowCountExt = 1;
			while @rowCountExt > 0
			begin
				begin transaction
					begin
						exec('DELETE TOP(10) FROM [' + @name + '] WHERE [deleted] = 1');
					end				
					set @rowCountExt = @@rowcount;
				commit transaction
			end			
	  end try		
	  begin catch	  
			rollback transaction;
			SELECT 
				@ErrorMessage = ERROR_MESSAGE(),
				@ErrorSeverity = ERROR_SEVERITY(),
				@ErrorState = ERROR_STATE();
			RAISERROR (@ErrorMessage,@ErrorSeverity,@ErrorState);
			return;
	  end catch

exec('DELETE TOP(10) FROM [' + @name + '] WHERE [deleted] = 1');

SELECT *
  FROM master.dbo.sysprocesses (nolock) 
 WHERE blocked > 0

declare @eventInfo nvarchar(max)
SELECT @eventInfo = (select t.text from sys.[dm_exec_sql_text](sp.sql_handle) t)		   
  FROM master.dbo.sysprocesses (nolock) sp
WHERE spid = @spid

declare @blocked_eventInfo nvarchar(max)
SELECT @blocked_eventInfo = (select t.text from sys.[dm_exec_sql_text](sp.sql_handle) t)		   
  FROM master.dbo.sysprocesses (nolock) sp
 WHERE spid = @blocked