views:

56

answers:

0

I altered a stored procedure in SQL Server Management Studio database and everything appeared as expected. When my ASP.NET website called that stored procedure, it complained of invalid arguments. After running the alter procedure and then drop/create procedure the website continued to complain of invalid arguments. Furthermore, after re-starting the computer, I re-examined the stored procedure and noticed that it was an older version without those "invalid arguments". After a few more attempts, of altering/dropping/creating the stored procedure everything works fine.

NOTE: I had clicked "Refresh" on the database between these various actions.

Has anyone else noticed these problems, and is there anything I can do to minimize the occurances?