"Find Unused Variables and Parameters" doesn't work with SQL2016 synthax
ralf
Posts: 4 Bronze 2
in SQL Prompt
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
"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
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.
Redgate Software
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 Bainbridge
Product Support Engineer | Redgate Software
you are right, with the latest version it is working now as expected.
Thanks for your feedback and best regards
Ralf