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?