Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  MSDE and MS SQL 2000 Standard Ed both installed

Author  Topic  scheney Starting Member 1 Post Posted - 2009-03-18 : 13:32:40 Hi I am using a SCADA program to log data to SQL. When you install the SCADA it automatically installs MSDE. Due to the 2GB limitation I needed the Standard Edition, so it was installed. Then I configured the ODBC and the Database in enterprise manager. When I tried to increase the database size, I was told that I still had a 2GB limit, realizing that I was still running Desktop Engine. When I went to Add/Remove tools, I saw two Desktop Engine loads and one SQL Server 2000 load. Can I remove the Desktop Engine loads, use only the Standard Edition and keep all my configurations? Can I even access the Standard Edition load currently?