April 22, 2012

sp_fulltext_recycle_crawl_log (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_fulltext_recycle_crawl_log(nvarchar @ftcat)

MetaData:

 create proc sys.sp_fulltext_recycle_crawl_log  
@ftcat sysname -- full-text catalog name
as
set nocount on

-- sp_fulltext_catalog will run under read committed isolation level --
set transaction isolation level READ COMMITTED

-- CHECK PERMISSIONS (must be a dbowner) --
if (is_member('db_owner') = 0)
begin
raiserror(15247,-1,-1)
return 1
end

if (db_name() in ('master','tempdb','model'))
begin
raiserror(9966, -1, -1)
return 1
end

-- VALIDATE PARAMS --
if @ftcat is null OR datalength(@ftcat) = 0 -- allow spaces in the name, but not a 0-length string
begin
raiserror(15600,-1,-1,'sys.sp_fulltext_recycle_crawl_log')
return 1
end

-- DISALLOW USER TRANSACTION --
set implicit_transactions off
if @@trancount > 0
begin
raiserror(15002,-1,-1,'sys.sp_fulltext_recycle_crawl_log')
return 1
end

declare @ftcatid smallint
select @ftcatid = fulltext_catalog_id from sys.fulltext_catalogs where name = @ftcat
if @ftcatid is null
begin
declare @curdbname sysname
select @curdbname = db_name()
declare @curdbnamelen int
select @curdbnamelen = LEN(@curdbname)
raiserror(7641,-1,-1,@ftcat, @curdbnamelen, @curdbname)
return 1
end

DBCC CALLFULLTEXT ( 20, @ftcat)

return 0

No comments:

Post a Comment

Total Pageviews