Pravasis
Default port
Points: 1455
More actions
December 29, 2010 at 8:12 am
#229901
Do we have any feature in SQL server (or any tool) which can help us to find out all the unused variables in a Stored procedure. Any information regarding this would be of great help.
Regards,Pravasis
Eric
SSCommitted
Points: 1803
December 29, 2010 at 10:22 am
#1267302
There are two tools I know of, both plugins for SSMS.
SQL Refactor from Apex SQL
http://www.apexsql.com/sql_tools_refactor.aspx
SQL Prompt (professional version) from Red Gate
http://www.red-gate.com/products/sql-development/sql-prompt/
December 29, 2010 at 11:21 am
#1267332
Eric Klovning (12/29/2010)There are two tools I know of, both plugins for SSMS.SQL Refactor from Apex SQLhttp://www.apexsql.com/sql_tools_refactor.aspxSQL Prompt (professional version) from Red Gatehttp://www.red-gate.com/products/sql-development/sql-prompt/
Eric Klovning (12/29/2010)
Thanks!
Really appreciate it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply