Can I use SQL Server Management Studio Express to connect to an MSDE database?

Question

Is it possible to use SQL Server Management Studio Express 2005 to connect to an MSDE database?

All good programmers are lazy, you know... so I figured it would be quicker to ask on SO than to actually try it... :) But seriously, I don't have access to the software to try it myself at the moment. — ObiWanKenobi, Jun 09 '09 at 19:44
which software do you need, you can download the SQL Server Management Studio Express 2005 for free. — J.W., Jun 09 '09 at 19:47

score 1 · Accepted Answer · answered Jun 09 '09 at 19:37

1

Yes.

(I've nothing else to add!)

answered Jun 09 '09 at 19:37

Michael Petrotta

score 0 · Answer 2 · answered Nov 30 '10 at 13:47

0

Yes you can. You can use SQL Server Management Studio Express 2008 also.

answered Nov 30 '10 at 13:47

Emre Seckin

score 0 · Answer 3 · answered Jun 09 '09 at 19:38

0

I don't think so, why not upgrade to SQL Express 2005, which is the replacement of MSDE.

answered Jun 09 '09 at 19:38

J.W.

...or SQL Express 2008, which is the replacement of SQL Express 2005 :) – D'Arcy Rittich Jun 09 '09 at 19:39

3 Answers3