Deepak Sahu (1/14/2011)
Could anyone throw somelight on , SQL Server Management Studio 2005 Express can connect to SQL Server 2008 Express databases?
I believe it does - as long as you have applied the latest service packs.
But, I have to ask why you would be concerned about that. Upgrade the client tools to the 2008 version (they are free) and use the 2008 tools to access the 2005 instances.
If you are using the Advanced Features, then you should install both clients side-by-side (I think that is possible for Express, but not sure).
And finally, if you have a licensed version of SQL Server 2008 that you connect to then you can install the full client tools. Those tools can be used to manage Express editions also. If you don't have a licensed version, it might be worth the cost to purchase the Developer Edition (~$50) which would give you the full version client tools.