April 25, 2012

sp_help_fulltext_catalog_components (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_help_fulltext_catalog_components()

MetaData:

 create procedure sys.sp_help_fulltext_catalog_components  
as
-- FULLTEXT MUST BE ACTIVE IN DATABASE --
if DatabasePropertyEx(db_name(), 'IsFulltextEnabled') = 0
begin
raiserror(15601,-1,-1)
return 1
end

-- dump all full-text components used in this database
select ftcat.name, ftcat.fulltext_catalog_id as ftcatid, componenttype, componentname, clsid,
(case when is_srvrolemember('serveradmin') = 1 then fullpath else NULL end) AS [fullpath],
version, manufacturer
from sys.fulltext_catalogs as ftcat cross apply sys.fn_ftcatcomponents(0, db_id(), ftcat.file_id) as ftcomp

No comments:

Post a Comment

Total Pageviews