What are the challenges you face when working across database platforms? Take the survey
Options

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

ralfralf Posts: 4 Bronze 2
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
Tagged:

Comments

  • Options
    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.
    Software Engineer
    Redgate Software
  • Options
    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.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Options
    ralfralf Posts: 4 Bronze 2
    Hi Dan,
    you are right, with the latest version it is working now as expected.
    Thanks for your feedback and best regards
    Ralf
Sign In or Register to comment.