Wednesday, March 21, 2012

number of connections

Hi,
I would like to know if I can over the limit of user connection using the
sqlserver 2005, that is 32,767 user connections(I know that I need some
hardware resource as memory, etc).
Thanks,
Serge
"Serge" <Serge@.discussions.microsoft.com> wrote in message
news:160EB448-A632-423D-BF14-7A372277BBF3@.microsoft.com...
> Hi,
> I would like to know if I can over the limit of user connection using the
> sqlserver 2005, that is 32,767 user connections(I know that I need some
> hardware resource as memory, etc).
>
I don't know of anyway.
But I'd be surprsied if you ever really needed to. That would be a MASSIVE
system that required that many simultaneous connections.
I'm curious what you're end-goal is.

> Thanks,
> Serge
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

No comments:

Post a Comment