Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #813

Re: What is the difference between my two sql server instances

Show all headers | View raw

Tony (johansson.andersson@telia.com) writes:
> I have SQL Server 2008
> If I look in the Sql Server Configuration Manager I can see that I have
> two instances of SQL server. 
> These are :
> SQL Server(SQLEXPRESS)
> SQL Server (MSSQLSERVER). This is the default instance.
> 
> I have installed the Pubs database and the Northind database in the
> default instance which is MSSQLSERVER. 
> 
> I know one difference between these two and that is I can only use
> property AttachDBFilename in SQLEXPRESS. I can create a database in both
> of these two and everying work fine. 
> 
> Now to my question are there any major differences between these two
> except the one that I mentioned ? 

Actually, AttachDBFilename is usable with any edition of SQL Server. The 
only Express-specific connection-string option I know of is UserInstance.
Which you should not use anyway - it has been deprecated in SQL 2012.

You don't say which edition you have in your default instance, but I assume 
that it is Developer Edition. There are quite a few more features in 
Developer Edition that are not available in Express. Developer Edition has
the same feature set as Enterprise Edition. The only difference to 
Enterprise is legal: Developer is not licensed for production use.

So if you are developing applications that will run on Express, it is 
important to test on a machine that only has Express, so that you don't
use something which is not supported in Express.

This link has details on what is available in what edition of SQL Server.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

What is the difference between my two sql server instances "Tony" <johansson.andersson@telia.com> - 2011-11-18 11:37 +0100
  Re: What is the difference between my two sql server instances Erland Sommarskog <esquel@sommarskog.se> - 2011-11-18 11:22 +0000
    Re: What is the difference between my two sql server instances "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-11-18 07:52 -0500
      Re: What is the difference between my two sql server instances Erland Sommarskog <esquel@sommarskog.se> - 2011-11-18 14:28 +0000
        Re: What is the difference between my two sql server instances "Tony" <johansson.andersson@telia.com> - 2011-11-18 15:58 +0100

csiph-web