Data Haunting

Easy Solutions Destination


Procedure or function expects parameter which was not supplied

We have seen this error number of  times that is “Procedure or function expects parameter which was not supplied”  in c# and sql server . Every time reason for this error is different . Today here I will explain different reasons for this most common error.


How to find table which is used in many stored procedures

Sometimes in sql server when we change in table column or schema it is very hard or difficult to find that given table is used in how many procedure because  some time it is necessary to find and make changes in most of stored procedure related to that particular table . So i find easiest way to find all stored procedure  by using following Sql query  in Sql Server 2012.