SQL Server Rant

posted @ Wednesday, March 30, 2005 12:43 PM

 

So I was finishing up a stored procedure this morning, saved it and then noticed that once the editor closed that I didn't prefix this particular stored procedure as I had all my previous to match. No problem, right-click on the stored procedure in the list and select “Rename” which will allow you to edit its name, it will confirm that you want to change it and it's a done deal, right? Nope, if you open the stored procedure back up you will notice that it didn't change its name 'internally' within the stored procedure; you have to manually edit it there as well. I don't know if this is a documented problem or not, is anyone else aware of this issue?