Sql Spell Checker

Question

I am just wondering if there is any utility that can help in determining spelling errors in sql objects.

I can only think about getting information about all sql objects and saving them in any other system (for example, an excel file), and then run a spell check on it.

I hope for a better way to do this, like any MSSQL plugin.

Answer 1

You can use the spell checker feature built into Office as a CLR function. See the example here: http://msdn.microsoft.com/en-us/library/office/aa537153%28v=office.11%29.aspx

To use this, you need to install MS Word on the server side.