How can we help you today? How can we help you today?

"Find Unused Variables and Parameters" doesn't work with SQL2016 synthax

Hi! If you have a SQL script with the new "IF EXISTS" clause for deleting a procedure ,the command "Find Unused Variables and Parameters" fails and returning the message
"Error find unused variables
SQL Prompt was unable to complete this Operation.
Problem areas have been highlighted."

USE [DWH1_Staging];
GO
DROP PROCEDURE IF EXISTS [export].[spBookingMergeInDWH];
GO
SET ANSI_NULLS ON;
GO

I'm working with Version 8.0.0.1241

Best regards
ralf
0

Comments

3 comments

Sort by
  • Rob C
    Hi Ralf,

    This is a known issue with SQL Prompt, with reference SP-6175. There isn't a workaround I'm afraid, but I'll let you know when I hear anything about a possible bugfix.
    Rob C
    0
  • Dan B
    Hi Ralf,

    We haven't been able to reproduce this in the latest version of SQL Prompt. So whilst we made no active attempt to fix this it looks like it has now been resolved.

    If you could upgrade to the latest version and let me know if you still see this and I will go from there.
    Dan B
    0
  • ralf
    Hi Dan,
    you are right, with the latest version it is working now as expected.
    Thanks for your feedback and best regards
    Ralf
    ralf
    0

Add comment

Please sign in to leave a comment.