connections

Hi ,
Want to calculate how much connections remaining in my db server . select
@.@.connections is a way to calculate no. of connections . Can I dedcut this
value from maximum connections & get the value .
Thanks
ARRSelect @.@.max_connections - @.@.connections
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
"Aju" <ajuonline@.yahoo.com> wrote in message
news:umachlvIFHA.3628@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> Want to calculate how much connections remaining in my db server . select
> @.@.connections is a way to calculate no. of connections . Can I dedcut this
> value from maximum connections & get the value .
> Thanks
> ARR
>