Number of Concurrent Queries

Hi,
I am developing an application that may required up to 68 concurrent
connections to the database. I was using MSDE 2000 until now. Since MSDE has
been optimized for 8 concurrent queries, I am planning to upgrade to SQL
Server Workgroup edition. When I was testing my application using SQL Server
2005 CTP Workgroup Edition I got the same error (8 concurrent queries). Is
this a limitation of SQL Server Workgroup edition or the CTP edition?
Aravind Melatur
Hi
Are you sure you connected to the CTP version and not MSDE?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Aravind Melatur" <AravindMelatur@.discussions.microsoft.com> wrote in
message news:6302E6AB-027D-4051-9F5C-8B402AFA69B2@.microsoft.com...
> Hi,
> I am developing an application that may required up to 68 concurrent
> connections to the database. I was using MSDE 2000 until now. Since MSDE
> has
> been optimized for 8 concurrent queries, I am planning to upgrade to SQL
> Server Workgroup edition. When I was testing my application using SQL
> Server
> 2005 CTP Workgroup Edition I got the same error (8 concurrent queries). Is
> this a limitation of SQL Server Workgroup edition or the CTP edition?
> --
> Aravind Melatur