You can use SQL Server Management Studio 2008 (which provides very helpful intellisense for writing queries) as a client to connect to SQL Server 2005 database service.

If you are using SQL Server Management Studio 2008 to connect to SQL Server 2008 database service, you should not attach database from SQL Server 2005 because it will upgrade the database so it cannot be used again by SQL Server 2005 database service.

September 9th, 2009