Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 SQL Server 2008. Please, need urgent advice. Thank

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-11-11 : 18:16:05
Hello,

I am developing a Windows WPF application to run on a local network.

This application is to be installed on 3 computers of the local network and will use an SQL 2008 database that should be shared and used by the 3 users.

What edition of SQL 2008 server should my client's network have?
And to access the SQL 2008 database in the application do I need only to use a connection string?

Thanks,
Miguel

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-11 : 19:00:17
The edition would dependent upon your requirements. Please compare the different editions to see what fits your needs.

Do you have application programming experience? Connecting to SQL Server 2008 is no different than connecting to other versions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-11-11 : 19:18:17
Hi,

I have been developing mostly ASP.NET Web Applications and ASP.NET MVC Web Applications using SQL 2005 and SQL 2008.

This is my first windows application and this is why I have some doubts.

I thought that SQL Express databases can only be accessed by one user and with a maximum size for 4 GB.
This is one of the items I was trying to clarify.

I was looking for a document that compare all editions.
For SQL 2005 I remember that was a nice online table comparing all the editions but for SQL 2008 I am not able to find the same.
Go to Top of Page

Elisabeth Redei
Starting Member

15 Posts

Posted - 2008-11-12 : 14:06:38
Hi,

Is this what you are looking for: "Features Supported by the Editions of SQL Server 2008"
http://msdn.microsoft.com/en-us/library/cc645993.aspx.

There was never a limit in number of connections but performance was throttled at a certain number of users (5 if I remember correctly) in MSDE. We don't do that anymore.

/Elisabeth


elisabeth@sqlserverland.com

Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-11-12 : 15:51:49
So you mean I can have SQL Express with 20 users connected to it at the same time right?
Go to Top of Page
   

- Advertisement -