SQL Prompt 6.0.0.136 - Find Unused Variables and Parameters

Ozzie19Ozzie19 Posts: 11
edited July 11, 2013 7:02AM in SQL Prompt Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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 DAnu D Posts: 876 Silver 3
    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
  • 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
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.