layout fails on statistics with system generated name

Provides intelligent code completion for SQL Server editors.

layout fails on statistics with system generated name

Postby fatherjack » Tue Aug 31, 2010 10:43 am

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].[table].[_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
Senior DBA
Careers South West Ltd
Posts: 224
Joined: Tue Mar 13, 2007 11:33 am
Location: Cornwall

Postby Anu Deshpande » Wed Sep 01, 2010 12:21 pm

Many thanks for your e-mail and apologies for inconvenience caused.

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.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests