SQL Prompt 6.0.0.136 - Find Unused Variables and Parameters

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt 6.0.0.136 - Find Unused Variables and Parameters

Postby Ozzie19 » Tue Jul 09, 2013 3:33 pm

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
Ozzie19
 
Posts: 6
Joined: Fri Mar 16, 2012 10:44 pm

Postby Anu Deshpande » Wed Jul 10, 2013 4:10 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Anu Deshpande » Wed Jul 10, 2013 4:57 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby JonathanWatts » Thu Jul 11, 2013 12:02 pm

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
JonathanWatts
 
Posts: 401
Joined: Wed Dec 15, 2004 11:05 am
Location: Red Gate Software


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests