Sorry, didn't realize this was SQL 2000. (Doh!)

Query Analyzer has a menu item for this. You select it before you run the query.

Don't be sure your schema and data are the same (indexing, etc.). Use a tool, or run queries and try to be sure. At least for the objects that you are using in the stored procedure. Assuming they are and not checking can end up wasting a lot of time.

Even if they were when you sync'd things, unless you are the only person that could possibly make changes on the dev server, you should check.