Error 207 Invalid column name

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 3120
Released: Jun 2, 2011
Updated: Jun 2, 2011 by MajikbyboB
Dev status: Stable Help Icon

Recommended Download

application, 614K, uploaded Jun 2, 2011 - 3120 downloads

Release Notes

There appears to be a defect in the sp_estimate_data_compression_savings system stored procedure if you have a table with a column that does not conform to the rules for regular identifiers. According to Books Online, for identifiers that do not conform to the rules, those identifers must be enclosed in double quotes or square brackets. This action is not being performed by the system stored procedure. As such, if you process a table with a non-regular identifier as a column name youi will receive an Error 207 Invalid column name. Calls to COL_NAME resolve correctly, so it appears to be a problem only in this stored procedure.

I am filing a bug with the Product Team.

This release just provides a bit more meaningful feedback to the user when this condition occurs.

Reviews for this release

A very useful and direct utility that helps you quickly analyze whether data compression will be useful on your SQL Server database, and then creates the scripts to implement data compression.
by kkline84 on Jul 7, 2011 at 11:21 PM