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