VS 2005 and SQL Server 2005 Developer

[Chris]

If i've installed SQL Server 2005 Developer, when I come to install VS 2005
is there any need to install SQL Server Express?

I would have thought the install would have detected SQL Server Developer
was installed and not select Express by default.
Do any examples projects for example rely on SQL Express being present?

Thanks,
Chris

 

[Cowboy \(Gregory A. Beamer\)]

No reason to install SQL Express if you have SQL 2005, but you do have to
turn off the option.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************

 

[Greg Burns]

I would disagree (tentatively). I haven't done much with SQL Express (or VB
2005 for that matter), but last few VB examples I've played with (see link)

http://msdn.microsoft.com/vbasic/downloads/2005/code/101samples/

(specifically Windows Forms's UsingDataGridView example)

relied on SQL Express's ability to dynamically load a database. I am still
learning 2005, but I don't think this is possible with Developer Edition.


Dim connectStringBuilder As New SqlConnectionStringBuilder()
connectStringBuilder.DataSource = ".\SQLEXPRESS"
connectStringBuilder.AttachDBFilename = "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf"
connectStringBuilder.IntegratedSecurity = True
connectStringBuilder.UserInstance = True

Obviously you could change the code, but the OP explicit asked if any of the
examples "rely on SQL Express being present".

(Please correct me if I'm wrong here.)

PS: I had a hell of a time getting the Adventure Works installed into the
Express instance. When I downloaded the AdventureWorksDB.msi it just
automatically installed into the Developer Edition instance. Very
frustrating. Eventually, I just manually attached it myself.

Greg