layout fails on statistics with system generated name
fatherjack2
Posts: 311
This happens in SQL Prompt 4 and SQL Refactor 1. Having written some script to drop some statistics auto created by the server then layout function fails with a 'syntax' error message with the first statistics name underlined in wavy red.
Parsing the TSQL shows no errors.
Executing the TSQL returns success.
The statistics name is "_WA_Sys_0000000B_7F948E70". The TSQL is simply:
DROP STATISTICS [schema]..[_WA_Sys_0000000B_7F948E70]
it makes no difference if I include [ and ] or not, or alter the script to have a different statistic as the first one. Which ever statistic is first causes the error.
Will test this with EAP 5 when the install is complete.
[Later ... ... quite a bit later]
this also fails with EAP5 5.0.0.224
Parsing the TSQL shows no errors.
Executing the TSQL returns success.
The statistics name is "_WA_Sys_0000000B_7F948E70". The TSQL is simply:
DROP STATISTICS [schema]..[_WA_Sys_0000000B_7F948E70]
it makes no difference if I include [ and ] or not, or alter the script to have a different statistic as the first one. Which ever statistic is first causes the error.
Will test this with EAP 5 when the install is complete.
[Later ... ... quite a bit later]
this also fails with EAP5 5.0.0.224
Senior DBA
Careers South West Ltd
Comments
I was able to replicate the problem and hence logged this as a bug in our internal tracking system whose tracking id is SP-3393 .
It will be reviewed by our development team and than marked for the release.
I will update you as soon as it is incorporated.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com