I had simplified the proc to the point of all it's doing is printing 'hello'...i disconnected from the database and re-connected now it compiles...
thats the problem... there isn't anything after the go.. strange isn't it?
I am scripting procedures together so I can have one script that creates a series of procedures. i've come across 1 procedure that I've broken down...
Separate names with a comma.