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_flush_commit_table_on_demand(bigint @numrows)MetaData:
CREATE PROC sys.sp_flush_commit_table_on_demand (@numrows as BIGINT = NULL) AS BEGIN IF (is_srvrolemember('sysadmin') = 0) BEGIN raiserror(21089,0,1) return 1 END IF (@numrows<=0) BEGIN raiserror(23100,0,1) return 1 END SET DEADLOCK_PRIORITY LOW -- checking for change tracking side table watermark DECLARE @cleanup_ts BIGINT SET @cleanup_ts = change_tracking_hardened_cleanup_version () -- checking for safe cleanup watermark DECLARE @cleanup_version BIGINT set @cleanup_version = safe_cleanup_version () IF @cleanup_ts > @cleanup_version SET @cleanup_ts = @cleanup_version IF (@numrows is null) BEGIN DELETE TOP(10000) sys.syscommittab WHERE commit_ts < @cleanup_ts WHILE(@@ROWCOUNT>0) DELETE TOP(10000) sys.syscommittab WHERE commit_ts < @cleanup_ts END ELSE IF( @numrows > 10000) BEGIN DELETE TOP(10000) sys.syscommittab WHERE commit_ts < @cleanup_ts SET @numrows-=10000 WHILE(@numrows > 0 and @@ROWCOUNT > 0) BEGIN DELETE TOP(10000) sys.syscommittab WHERE commit_ts < @cleanup_ts SET @numrows-=10000 END END ELSE DELETE TOP(@numrows) sys.syscommittab WHERE commit_ts < @cleanup_ts DECLARE @dbname sysname SET @dbname= DB_NAME() raiserror(21092,-1,-1,@dbname) WITH LOG END
No comments:
Post a Comment