Thursday, March 22, 2012

How can i Limit open connection on my sql server sql
server?sp_configure 'user options',100 for 100 connections
THis can also be set in SQL Enterprise Manager.. Right click your server and
go to properties...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"'" <anonymous@.discussions.microsoft.com> wrote in message
news:2a49f01c4659d$26b20bd0$a301280a@.phx
.gbl...
> How can i Limit open connection on my sql server sql
> server?

No comments:

Post a Comment