Red Gate forums :: View topic - Error during "find unused variables and parameters"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Error during "find unused variables and parameters"

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
georhill



Joined: 27 Jan 2011
Posts: 13

PostPosted: Tue Jan 29, 2013 7:30 pm    Post subject: Error during "find unused variables and parameters" Reply with quote

The "find unused variables and parameters" functionality of SQL Prompt 5 is very useful to me for cleaning up T-SQL.

Unfortunately it has stopped working on my machine (Windows 7 32-bit, SQL Server 2008 R2).

I get a "Notify Red Gate of this error" when I invoke it with the error details: Exception withing progress task".

Other SQL Prompt 5 functions like "format sql", "uppercase keywords" work fine.

Has anyone experienced this? Any ideas about fixing it would be welcomed.[/img]
Back to top
View user's profile Send private message
John Palmer



Joined: 21 Jun 2012
Posts: 6

PostPosted: Wed Jan 30, 2013 3:13 am    Post subject: Reply with quote

Yes, I can't say exactly which upgrade broke this, but it's not working for me either in ver 5.3.6.28 and I'm fairly certain for at least version prior to this.
Back to top
View user's profile Send private message
georhill



Joined: 27 Jan 2011
Posts: 13

PostPosted: Wed Jan 30, 2013 3:42 am    Post subject: Reply with quote

To close the loopon this issue...

I contact Red Gate support earlier today about this. They pointed me to a different (later) version of SQL Prompt on their FTP site. After I uninstalled the version I had and installed the new one the problem went away. I'd recommend you contact Red Gate support. They were very responsive when I contacted them by phone.
Back to top
View user's profile Send private message
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Mon Mar 18, 2013 2:47 pm    Post subject: Reply with quote

I am having the same issue with 5.3.6.28

I dont see any new patches on the ftp site.

Any one know where i get the fix for this.
Back to top
View user's profile Send private message Send e-mail
georhill



Joined: 27 Jan 2011
Posts: 13

PostPosted: Mon Mar 18, 2013 3:06 pm    Post subject: Reply with quote

The fix that Red-Gate provided earlier is no longer working. The same error is occurring again. I'm on 5.3.6.28. I think I updated SQL Prompt a few days ago and that must be when the problem came back. Time for another Red-Gate ticket.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group