May 14, 2012

sp_MSfast_delete_trans (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_MSfast_delete_trans()

MetaData:

 CREATE PROCEDURE sys.sp_MSfast_delete_trans  
as
begin
declare @retcode int

--
-- security check is done in sp_MSdrop_snapshot_dirs
--
EXEC @retcode = sys.sp_MSdrop_snapshot_dirs
if( @retcode <> 0 or @@error <> 0 )
return 1

truncate table MSrepl_commands
truncate table MSrepl_transactions
end

No comments:

Post a Comment

Total Pageviews