application given en error when parameters in stored procedure is changes [modified]
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I am developing application in asp.net 2.0 using C#. My back end is sql server 2005. I also use microsoft enterprise library 2006. My problem is: First i pass three parameters to stored procedure from the application. After i increase one more parameter in both application as well as stored procedure, the application gives an error that parameter does not match with the stored procedures parameters. after couple of hours when i restart the machine and again run the application it works fine with four parameters. does sql server 2005 stores the parameters in cache?? if it does not keep it in cache then how come i get an error that values does not match the values in the stored procedure??
modified on Monday, April 28, 2008 10:30 AM