Hello!

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 ?
So it doesn't matter which one I choose.

//Tony

Tony (johansson.andersson (AT) telia (DOT) com) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog wrote:
You forgot the link. Unfortunately I don't have it handy but it's easily
found by going to microsoft.com and searching for sql server. Once you're at
the sql server site, it's just a matter of looking on the page for the
appropriate link.

Bob Barrows (reb01501 (AT) NOSPAMyahoo (DOT) com) writes:
Thanks for pointing it out, Bob!

This is the link I had in mind:
http://msdn.microsoft.com/en-us/library/cc645993.aspx


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> skrev i meddelandet
news:Xns9FA19D578BECYazorman (AT) 127 (DOT) 0.0.1...

I can see that I have the following editions SQL server
Microsoft SQL Server Standard Edition and
Microsoft SQL Server Express Edition

//Tony