I have an application running on SQL Express SQL 9.0. Are there any known problems installing a Development Edition of MS SQL Server 2008 R2 along side SQL Express? In other words, is there a known problem having two different flavors of SQL Server installed? Is the Development edition treated like a second instance?
I know you can have multiple instances of SQL Server, with only one instance allowed as the unnamed or default instance. I'm just curious if anyone knows of a gotcha.