Other News

Editorials

Should You Use Null With Bit Columns?

Nulls in a database have been an area of contention since they were first available and implemented. The primary purpose of null as originally designed was as a placeholder where no value was available. In the case of true/false null provided a tertiary value of unknown, or undefined. You will get a lot of helpful information about null and how […]

Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 Full-Text Search Stored Procedures

Undocumented SQL Server 2012 Full-Text Search Stored Procedures SQL Server 2012 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog name...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here