thanks,

is there a query for maximum number of concurrent connections?

what happened when I ran it...

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '+'.

Msg 319, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'with'. If this...

Yes, what you described is what I am looking for... 🙂

your right, duh.

I thought I tried that before. Thanks!

Thanks! I need to learn more keywords 😀

http://www.1keydata.com/sql/sql-syntax.html