When I right click on a stored procedure (on SQL 2008) and hit edit it puts an
extra semi-colon at the end of the stored procedure. So when I go to hit Ok it
errors telling me incorrect syntax. If I remove the semi-colon at the end
everything works like a charm.
“Don’t worry if it doesn’t work right. If everything did,
you’d be out of a job.”
(Mosher’s Law of Software Engineering)