unused variables

4 Aug 2006 7:09 PM

Bill

I'd like to eliminate any unused variables that are used in my stored
procedures. However, since I have hundreds of stored procedures this would
be quite time-consuming doing this manually. Does someone know of a
utility/tool that does this?

4 Aug 2006 8:04 PM

Hari Prasad

Hi Bill,

There is no tool which will help you to identify the unused variables. Only
way to do is by opening and investigating each of the stored procedures. I
love if there is a way to do this automatically.....

Thanks
Hari
SQL Server MVP

Show quote

"Bill" wrote:

> I'd like to eliminate any unused variables that are used in my stored
> procedures. However, since I have hundreds of stored procedures this would
> be quite time-consuming doing this manually. Does someone know of a
> utility/tool that does this?

5 Aug 2006 7:50 PM

--CELKO--

>> I'd like to eliminate any unused variables that are used in my stored procedures. However, since I have hundreds of stored procedures this would be quite time-consuming doing this manually. Does someone know of a utility/tool that does this? <<

Nope. This will be quite time-consuming because you have to do it
manually. However, if you have a budget to develop software, there is a
company in Austin that writes parser tools for cleaning up C and other
code.