25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
hi Tom,
Tom Celica wrote:
> In the MSDE Edition of Sql Server 2000 there is a limit of 25
> connections. What is the definition of a "connection"? For
> example, if I create a connection pool of 5 connections in an
> application, does that count as 5 against the 25?
there's not such a limit of "25 connection"... this magic number is just a
guess about the probably supported load of an MSDE instance.. and it fo
course is influenced by your architectural design, both within the db and
the app...
please have a look at
http://msdn.microsoft.com/library/?u...asp?frame=true
for all available info about the built in Workload Governor..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
I didn't know there was a hard limit but the soft limit was actually 5.
Over 5 concurrent connections and it would start to throttle back your
performance. I don't know for sure but the license probably states a limit
of 5 concurrent connections. It was not intended to be used for that many
connections. That is what the standard edition is for. A connection is
anytime someone is connected to the server. If the pool has 5 open
connections then it is 5 connections.
Andrew J. Kelly SQL MVP
"Tom Celica" <tom@.dontreply.com> wrote in message
news:V1%Ae.1617$_%4.505@.newssvr14.news.prodigy.com ...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>
|||AFAIK there is no such limit. What makes you say that the limit is 25?
MSDE is optimized for 5 connections or less so if you want 25
connections you should probably be considering Standard or Workgroup
edition.
David Portas
SQL Server MVP

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-TomIndependently answered to many of the independently posted questions.
Please refrain from posting the same question independently to multiple
newsgroups.
"Tom Celica" <tom@.dontreply.com> wrote in message
news:s3%Ae.1619$_%4.824@.newssvr14.news.prodigy.com...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-TomI didn't know there was a hard limit but the soft limit was actually 5.
Over 5 concurrent connections and it would start to throttle back your
performance. I don't know for sure but the license probably states a limit
of 5 concurrent connections. It was not intended to be used for that many
connections. That is what the standard edition is for. A connection is
anytime someone is connected to the server. If the pool has 5 open
connections then it is 5 connections.
Andrew J. Kelly SQL MVP
"Tom Celica" <tom@.dontreply.com> wrote in message
news:V1%Ae.1617$_%4.505@.newssvr14.news.prodigy.com...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>|||AFAIK there is no such limit. What makes you say that the limit is 25?
MSDE is optimized for 5 connections or less so if you want 25
connections you should probably be considering Standard or Workgroup
edition.
David Portas
SQL Server MVP
--

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
Independently answered to many of the independently posted questions.
Please refrain from posting the same question independently to multiple
newsgroups.
"Tom Celica" <tom@.dontreply.com> wrote in message
news:s3%Ae.1619$_%4.824@.newssvr14.news.prodigy.com ...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>

25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-TomIndependently answered to many of the independently posted questions.
Please refrain from posting the same question independently to multiple
newsgroups.
"Tom Celica" <tom@.dontreply.com> wrote in message
news:s3%Ae.1619$_%4.824@.newssvr14.news.prodigy.com...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>

2005 clr returning xmldocument

I would like to return an xmldocument from a 2005 vb clr stored procedure.

This is my definition for the stored procedure. passing in a string, return xmldoc.

Can I not return an xmldoc as output? The solution will build, but not run.

Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Sub SP_Transform(ByVal cc As String, <Out()> ByVal RetValue As XmlDocument)

Error 1 Column, parameter, or variable #2: Cannot find data type XmlDocument. SqlServerProject1

Interesting question. I'll have to try it.

My gut, however, is that you should just return the XML data using the new Xml Data Type in SQL Server 2005 and just use a DataReader like dr.GetSqlXml(index) in ADO.NET to read the XML and load it into an XmlDocument.

I wrote an example of that here-

Reading XML Data Type into XmlDocument Using ADO.NET - SQL Server 2005 Tutorials

Regards,

Dave