This is really strange. I have several stored procedures that I copied and pasted into the SQL Server Query Analyzer to make some changes to the stored procedures. When I finished making the changes I then copied and pasted them back into the stored procedure. This has been working fine until a few weeks ago when I a new drive was added to my SQL server computer and I added 5GB out of the new drive to my database. Now when I copy and past the changed procedure back into the original procedure it works fine until the next day. When I go back into the stored procedure it reverts back to the old procedure and not the new(changed) procedure. This server being is used for development only and I'm the only one using it. Is there any settings I need to change to compensate for the new drive? Or Any suggestions as to why this is happening? Thought it was just me not saving the new procedure but these new procedures were used through out the day to make tables so I know it was there.
Thanks for all your help
Cathy
Thanks for all your help
Cathy
