SQL Server / SQL Express?

[dseydel]

Is the SQL Server that is distributed with Vis Studio 2005 SQL Express? Or is SQL Express only available as the Download? An MSDN article "Using SQL Express from Visual Basic 6" talks about an "Express Manager" that I can't find.

Any help appreciated.

Later That Same Day .... Found the answer. It is SQL Express. I think the "Express Manager" must be an earlier
version of the MSSMSE management tool.

 

[JohnH]

For the different SQL versions with the different Visual Studio versions see this page http://msdn.microsoft.com/vstudio/products/compare/default.aspx

 

[dseydel]

Well, I'm still confused about the SQL versions. The product spec chart for VS 2005 Pro shows that the SQL version is the Developer version. But when I use the SQL Management Server Express tool, everything shows up as SQLExpress and the connection strings I use are all Express strings.

So what is the difference between the Developer version & the Expresss version?

Thanks,
Don Seydel

 

[JohnH]

Features of SQL 2005 versions http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Developers Edition is (perhaps) the Enterprise Edition but only license for one developer.

 

[TechGnome]

In a nutshll, the Express edition is just the engine... much like the older MSDE form SQL2000. It does NOT include any of the client tools to manage it with. The developer version does come with those tools.

-tg