An error occurs when an extra parameter is increased in application as well as stored procedure to the existing one
-
Hi, I am using sql server 2005 and ASP .Net 2.0, VS 2005. When I increased a parameter in Stored Procedure and in application, and again running the application it throws an error that, Parameters does not match with the stored procedure parameters. All i have to do is restart the machine and again run the application. Then it does not throw the error and it works fine with the extra parameter in application as well as in storedproc. I am unable to understand what is the exact problem, that i have to restart the machine and then it accepts the changes
Sandeep Kumbhar
-
Hi, I am using sql server 2005 and ASP .Net 2.0, VS 2005. When I increased a parameter in Stored Procedure and in application, and again running the application it throws an error that, Parameters does not match with the stored procedure parameters. All i have to do is restart the machine and again run the application. Then it does not throw the error and it works fine with the extra parameter in application as well as in storedproc. I am unable to understand what is the exact problem, that i have to restart the machine and then it accepts the changes
Sandeep Kumbhar
-
What machine are you restarting? The user's the web server sql server After the restart has the SP changed at all?
The answers posted by me are suggestions only and cannot be used in anyway against me.
i am restarting the machine on which i am developing the application. when the changed the parameters in application as well as stored procedures and running the application it gives me error that parameter does not match. after the restart the machine it works fine with the changed parameters
Sandeep Kumbhar
modified on Friday, September 19, 2008 1:25 AM