Red Gate forums :: View topic - layout fails on statistics with system generated name
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

layout fails on statistics with system generated name

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Tue Aug 31, 2010 11:43 am    Post subject: layout fails on statistics with system generated name Reply with quote

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 5.0.0.224
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Wed Sep 01, 2010 1:21 pm    Post subject: Reply with quote

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.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group