Todd,

Thanks for the suggested changes. I’m going to try to get the unsupported data type columns to show up in the output, but not analyze the data in...

First off, this was a great article followed by an awesome thread… great suggestions, dialog, debates and explanations. Even though Jeff was kind enough to update the article...

Another possible reason to store human readable/searchable codes, keys, identifiers, etc. as character data might be full text indexing. FTI will not index integer columns.

Handy script, Thanks!! Many for the DB's I run into have nvarchar(max) columns. Any feel for how to address these?

Here is one approach for converting images into table columns with SQL.

This assumes that:

- you have a table with an identification that can be tied to the...