Nathan Thorell

### Search before asking - [x] I searched the [issues](https://github.com/sqlfluff/sqlfluff/issues) and found no similar issues. ### What Happened In the tsql dialect, when I have a statement like: ```sql DBCC...

TSQL: add fulltext catalog and openxml plus other fixes

2

### Brief summary of the change made fixes #6850 - Adds support for Create FullText Catalog - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-catalog-transact-sql - OpenXml added - https://learn.microsoft.com/en-us/sql/t-sql/functions/openxml-transact-sql - CreatePartitionFunction updated to include Hexadecimal -...