Here is a T-SQL query to get the Full text catalogs associated with a particular database
Use <Database Name> SELECT DB_Name() AS DatabaseName, name FROM sys.fulltext_catalogs; GO
To get the Full text catalogs associated with all databases in a instance, use the above query with sp_msforeachdb
Exec sp_msforeachdb ' USE [?]; SELECT DB_Name() AS DatabaseName, name FROM sys.fulltext_catalogs;' GO
No comments:
Post a Comment