Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 1st, 2009, 12:51 AM
Friend of Wrox
 
Join Date: Dec 2008
Posts: 119
Thanks: 26
Thanked 0 Times in 0 Posts
Default SQL Server 2005 vs SQL Server Express

The web host I'm planning to use said they support SQL Server Express so should I still install SQL Server 2005? I have it but I'm currently using SQL Express Edition 2008.

Rachel
 
Old March 1st, 2009, 03:28 PM
Friend of Wrox
 
Join Date: Dec 2008
Posts: 119
Thanks: 26
Thanked 0 Times in 0 Posts
Default

never mind. I'm going to use the express. I just saw what the real sql standard cost!
 
Old March 1st, 2009, 04:05 PM
Friend of Wrox
Points: 546, Level: 8
Points: 546, Level: 8 Points: 546, Level: 8 Points: 546, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2009
Posts: 105
Thanks: 3
Thanked 20 Times in 19 Posts
Default

You can do pretty much anything with the free SQL Express that you can with the paid version of SQL Server, other than the CPU limits and database size.

Visual Studio has a nice interface into SQL, but it does have limitations. To fully experience SQL you can download the management console for free. This will allow you to run queries in a test mode to get them doing just what you want before creating a stored procedure.

One downside is that you can't use Visual Studio and the SQL management console to connect to the database at the same time.

Depending on who is hosting your web site you may be able to use the SQL Management console to administer your database, which is a good thing if it's allowed. So you will need it on your machine and will need to be familar with it.
The Following User Says Thank You to Steve S For This Useful Post:
Rachel (March 1st, 2009)
 
Old March 1st, 2009, 04:09 PM
Friend of Wrox
 
Join Date: Dec 2008
Posts: 119
Thanks: 26
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Steve S View Post
You can do pretty much anything with the free SQL Express that you can with the paid version of SQL Server, other than the CPU limits and database size.

Visual Studio has a nice interface into SQL, but it does have limitations. To fully experience SQL you can download the management console for free. This will allow you to run queries in a test mode to get them doing just what you want before creating a stored procedure.

One downside is that you can't use Visual Studio and the SQL management console to connect to the database at the same time.

Depending on who is hosting your web site you may be able to use the SQL Management console to administer your database, which is a good thing if it's allowed. So you will need it on your machine and will need to be familar with it.
You are speaking of the Sql server management studio? I do have that.

Thanks,
Rachel
 
Old May 9th, 2009, 01:08 PM
Authorized User
 
Join Date: Jul 2006
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Steve S View Post
One downside is that you can't use Visual Studio and the SQL management console to connect to the database at the same time.
You can attach both to the database at the same time. Once you attach the beerhouse in management studio, you need to 1. create a new data connection in the VS server explorer window instead of the ASPNETDB.MDB. 2. Then alter the connection string in web.config - for example:
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Initial Catalog=BEERHOUSE(the name you assigned in 1.) ;Integrated Security=True" providerName="System.Data.SqlClient"/>





Similar Threads
Thread Thread Starter Forum Replies Last Post
Remoting and SQL Server 2005 Express Bob Bedell C# 2005 15 January 3rd, 2008 01:52 AM
Using SQL Server 2005 express advance service wisnu BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 2 January 11th, 2007 03:40 PM
SQL SERVER 2005 STANDARD (not express) proslambano BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 8 January 8th, 2007 08:55 PM
SQL Server 2005 Express Problem asped_man BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 3 November 29th, 2005 05:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.