Sunday, March 11, 2012

Can Management Studio Express manage SQL 2000?

Can I use SQL Server 2005 Management Studio Express to manage existing SQL Server 2000 instances?

Yes, it can. I've suggested that people set this up when the non-Express version wasn't available and it works beautifully. Well, almost. The only thing I know you need to look out for is generated SQL scripts. Sometimes they aren't compatible with SQL Server 2000. That's the only thing I've run into, tho.

Hope this helps!

No comments:

Post a Comment