when you edit a stored procedure from the VS 2008 Server Explorer, and try to save it, the yellow bar on the left side (next to the line numbers) does not change from yellow to green indicating changes saved.

The only way to know if saved is if the * is disappeared from the tab title, or the saving indicator.Wink