dhayes,
I guess you are new to SQL 🙂
The first time you ran the script, you were creating a stored procedure, teh scond time errored, as you found out, because the proc already exists!
To run the proc use
exec dba_WhatSQLIsExecuting
ensuring you are in the right database.....
Kev