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 MelaturHi
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