When you hear about breaches, so many times it’s because someone didn’t do their job protecting their SQL Server, protecting the data, or protecting the pipes that feed and move the data around. It’s a big deal – and with your (likely) cloud environment, the model and approach to all of this is changing. Chain of custody… “that records the […]
Undocumented SQL Server 2017 Full-Text Search and XML procedures
Undocumented SQL Server 2017 Full-Text Search and XML procedures SQL Server 2017 supports the following useful undocumented SQL Server Full-Text Search and XML procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_syscollector_validate_xml sp_xml_schema_rowset sp_xml_schema_rowset2 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 = ]...