SQLEXPRESS instance on SQL SErver 2005 standard edition

What happens when you install a SQLEXPRESS instance on a machine that
already has SQL Server 2005? Will the SQLEXPRESS still run in the limited
mode or will it sense that an full standard version of SQL Server 2005 is
already present and just "upgrade" itself?
On the otherhand, how do I "upgade" an existing instance of SQLEXPRESS to a
full version of SQL Server 2005 standard edition without uninstalling and
installing the standard edition. If I have both the instances then will the
SQLEXPRESS be freed from its limits?

Thanks,

Vikram


--



.

Relevant Pages

  • Re: windows xp update weirdness
    ... Make sure the SQL Server service [SQL Server (SQLEXPRESS)]is set to startup automatically in the Services console Start> Run> type in services.msc ... showing for the updates that failed to install or, see if there were KBxxxxxx.logs ...
    (microsoft.public.windowsupdate)
  • Re: Install SQL Expr after DEV Edition
    ... If you want your SQL Server Express Edition' s name as "SQLEXPRESS" then this means that you want to install this instance as a Named Instance. ...
    (microsoft.public.sqlserver.setup)
  • Re: vbexpress and sql2000
    ... I did run the install of SQLserverExpress. ... My question is can you have SQL2000 and SQLExpress running on the same PC, ... If you can have bot sql server versions running, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Using JDBC for SQLExpress
    ... portnumber for the SQLEXPRESS instance. ... We retrieve the port number by ... this service in the SQL Server Configuration Manager that installed with Sql ... This alias is for newsgroup purposes only. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: SQLExpress New DB
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... SQLEXpress onto my PC which is running VISTA Home Premium. ... I am pretty certain it is a rights issue, ... Is the database being created on the same ...
    (microsoft.public.sqlserver.connect)