UNfortunately you canot connect from SQL2005 to SQL 2008
(Katmai) from management studio, or can you. It appears the validation code is
in the main connection dialog. However if you use SQLCMD mode you will be
fine.
So connect to you SQL2005 server and then issue a
:connect MyKatmaiServer
Anything after that line will be executed against your katmai server.
Ok so you can't use the UI but at least you can run
scripts.