Stored Proc Contents Missing
Posted on 2008-10-16
I created a large stored proc a couple of days ago and it had been running fine and updating my tables as intended. I noticed this morning, that my data was not being updated via the proc and went into sql 2005 management studio right clicked on the procedure under stored procedures, .. clicked modify and noticed that the proc had only 10 lines of system generated code with the name of my procedure in it, but none of the sql that I wrote for this procedure. what has happened, am I missing something???