I know very little about databases and SQL Server and wanted to know if MSDE and SQL can run on the same box. If not, if I install SQL 2000 on this box will it "upgrade" the other two databases and run under SQL Server?
My experience with software vendors has been they do not recommend multiple databases -- one reason is running in a mixed or a non-mixed mode.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading