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.
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 |
|
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. |
|
|
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./Elisabethelisabeth@sqlserverland.com |
|
|
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? |
|
|
|
|
|