开发者

SQL server: How to check database has catalog or not

开发者 https://www.devze.com 2022-12-20 03:27 出处:网络
I am trying to find out whether a database has a catalog开发者_Go百科 or not. I couldn’t find any system stored procedure to perform this task.

I am trying to find out whether a database has a catalog开发者_Go百科 or not. I couldn’t find any system stored procedure to perform this task.

I need to find the catalog first then perform Full text search. If a catalog is not found, full text search is ignored.


In SQL Server 2005 or later, have you tried the following?

select is_fulltext_enabled from sys.databases
0

精彩评论

暂无评论...
验证码 换一张
取 消