InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:16:21 GMT20http://www.sqlservercentral.com/Forums/Topic1398254-1371-1.aspxVery interesting! I had not considered this. The issue would be identifying such a case since comments can be in many different forms:--@my_unused_parameter-- @my_unused_parameter-- need to clean this up one day! -&gt; @my_unused_parameter/* @my_unused_parameter *//*@my_unused_parameter*/Etc... You've given me some food for thought. Thanks for sharing! :)Wed, 19 Dec 2012 10:32:46 GMTSean Smith-776614http://www.sqlservercentral.com/Forums/Topic1398254-1371-1.aspxNice! I've been thinking about this as well. But the problem has been how to exclude comments in the query of the module definition. For example, if I've got a @ParamA parameter that's not used in the code but is included in a comment, I still want this reported since the parameter isn't used. It just happens to be referenced in a comment.Wed, 19 Dec 2012 10:22:55 GMTcharles.jacobus-765275http://www.sqlservercentral.com/Forums/Topic1398254-1371-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/unused/95259/">Unused Input Parameters</A>[/B]Wed, 19 Dec 2012 02:51:02 GMTSean Smith-776614