Columns with imbedded ampersand (&)

Jun 2, 2011 at 4:19 AM


This is shaping up to be a great tool - Thanks.

I am receiving an unhandled exception error when I run against a database that contains & characters in the column name.

Error as follows:

Invalid column name 'OrgESA_13WkFull&Path_Outcomes'.




Jun 2, 2011 at 12:34 PM

I'll take a look at it. Do you use QUOTED IDENTIFIERs in this database? Also, is it during the processing, or the script creation, or the execution of the script that this error occurs?


Jun 2, 2011 at 1:29 PM

There appears to be a defect in the system stored procedure that provides the estimate of savings for compression. It does not correctly handle the case you have identified. I am filing a bug with the Product Team. Until then I can't fix this one. I did provide a minor release that at least gives a more meaningful message to the user. Thank you for your feedback.