It’s been ages since I’ve had a properly geek post, so here you go: one really annoying thing about SQL Server 2000’s stored procedures is that it doesn’t automatically update the relevant script if you update the stored procedure name. The solution is to manually update the name in the script, or you’ll get a lovely SQL-DMO error 21037.