Red Gate forums :: View topic - SQL Prompt 6.0.0.136 - Find Unused Variables and Parameters
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt 6.0.0.136 - Find Unused Variables and Parameters

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Ozzie19



Joined: 16 Mar 2012
Posts: 6

PostPosted: Tue Jul 09, 2013 3:33 pm    Post subject: SQL Prompt 6.0.0.136 - Find Unused Variables and Parameters Reply with quote

RG,

Whenever I click on this option, or press Ctrl+B, Ctrl+F - I get a runtime error. The error looks like this in the log.

09 Jul 2013 14:25:09,186 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Creating menus for SQL Prompt edition Trial
09 Jul 2013 14:25:10,515 [14] WARN . - Couldn't find table 6980543 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,516 [14] WARN . - Couldn't find table 198981227 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,517 [14] WARN . - Couldn't find table 403141573 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,518 [14] WARN . - Couldn't find table 478494075 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,518 [14] WARN . - Couldn't find table 530178476 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,519 [14] WARN . - Couldn't find table 530178476 for PK column 2, perhaps it's on a table type
09 Jul 2013 14:25:10,520 [14] WARN . - Couldn't find table 530178476 for PK column 3, perhaps it's on a table type
09 Jul 2013 14:25:10,520 [14] WARN . - Couldn't find table 729209798 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,521 [14] WARN . - Couldn't find table 827866016 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,521 [14] WARN . - Couldn't find table 896175134 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,522 [14] WARN . - Couldn't find table 896175134 for PK column 2, perhaps it's on a table type
09 Jul 2013 14:25:10,522 [14] WARN . - Couldn't find table 896175134 for PK column 3, perhaps it's on a table type
09 Jul 2013 14:25:10,523 [14] WARN . - Couldn't find table 896175134 for PK column 4, perhaps it's on a table type
09 Jul 2013 14:25:10,524 [14] WARN . - Couldn't find table 1016442745 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,524 [14] WARN . - Couldn't find table 1022886961 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,525 [14] WARN . - Couldn't find table 1086144602 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,525 [14] WARN . - Couldn't find table 1754462766 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,526 [14] WARN . - Couldn't find table 1898463279 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:25:10,526 [14] WARN . - Couldn't find table 2010034492 for PK column 1, perhaps it's on a table type
09 Jul 2013 14:26:39,348 [23] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.VisualStudio.Package.LanguageService.ParseThread()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

Best,
Ozzie
_________________
Doug
Back to top
View user's profile Send private message Send e-mail
Anu Deshpande



Joined: 20 Apr 2009
Posts: 689
Location: Cambridge

PostPosted: Wed Jul 10, 2013 4:10 pm    Post subject: Reply with quote

Many thanks for your post.

We have logged a support call for you, call reference for which is F0074878.
_________________
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
Anu Deshpande



Joined: 20 Apr 2009
Posts: 689
Location: Cambridge

PostPosted: Wed Jul 10, 2013 4:57 pm    Post subject: Reply with quote

Can you please share your email address as the one registered on this forums does not work, I got a delivery failure notification?
_________________
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
JonathanWatts



Joined: 15 Dec 2004
Posts: 399
Location: Red Gate Software

PostPosted: Thu Jul 11, 2013 12:02 pm    Post subject: Reply with quote

If you could share the script you are attempting to use find unused variables on then we can take a look at this and see what is going on.

Alternatively you can email it to jonathan [dot] watts [at] red-gate [dot] com.

Thanks

Jonathan
- SQL Prompt Team
Back to top
View user's profile Send private message
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