I executed the code against a 2008 server and a 2005 server and got this message both times:

[font="Courier New"]Msg 911, Level 16, State 1, Line 1

Database 'test2' does not exist. Make sure that the name is entered correctly.

Msg 2714, Level 16, State 3, Procedure sp_one, Line 3

There is already an object named 'sp_one' in the database.

(1 row(s) affected)[/font]

and this result:

[font="Courier New"]this [/font]

:ermm: