Skip to content

SQLServerLearner

Learn SQL Server Online

  • SQL Server Error List
    • SQL Server error messages list 0 to 1000
    • SQL Server error messages list 1000 to 2000
    • SQL Server error messages list 2000 to 3000
    • SQL Server error messages list 3000 to 4000
    • SQL Server error messages list 4000 to 5000
    • SQL Server error messages list 5000 to 6000
    • SQL Server error messages list 6000 to 7000
    • SQL Server error messages list 7000 to 8000
    • SQL Server error messages list 8000 to 9000
    • SQL Server error messages list 9000 to 10000
    • SQL Server error messages list 11000 to 14000
    • SQL Server error messages list 14000 to 16000
    • SQL Server error messages list 16000 to 18000
    • SQL Server error messages list 18000 to 22000
    • SQL Server error messages list 22000 to 39000
    • Other Languages
      • SQL Server error messages list 0 and 5000 in German
      • SQL Server error messages list 2000 to 5000 in Traditional Chinese
      • SQL Server error messages list 5000 and 10000 in German
      • SQL Server error messages list 8000 to 10000 in Traditional Chinese
      • SQL Server error messages list 0 and 5000 in French
      • SQL Server error messages list 0 to 2000 in Traditional Chinese
      • SQL Server error messages list 10000 and 20000 in German
      • SQL Server error messages list 10000 and 20000 in Traditional Chinese
      • SQL Server error messages list 10000 to 20000 in French
      • SQL Server error messages list 20000 and 50000 in German
      • SQL Server error messages list 20000 and 50000 in Traditional Chinese
      • SQL Server error messages list 5000 to 10000 in French
      • SQL Server error messages list 5000 to 8000 in Traditional Chinese
  • Video Tutorials
  • SQL SERVER LINKS
    • SQL Server Collations
    • t-sql code examples
    • All Posts
      • Random Posts
      • SQL SERVER History
  • About
    • Contact Me
    • Outsource DBA
  • Copyright
  • SQL Server DBA Opening in TCS

Tag: need of @@connections variable sql server

USING @@CONNECTIONS VARIABLE

Posted on June 20, 2011July 11, 2020 by deviprasadg
@@CONNECTIONS Variable contains the number of connections that were called on to the SQL Server Service.
This number includes both Successfull and unsuccessful connections.
Basic Syntax for using @@CONNECTIONS:


SELECT @@CONNECTIONS

 

Output for the Above query would give the following depending up on your server:

 

Posted in SQL SERVER VARIABLES, SQLServerPedia SyndicationTagged @@connections, @@connections global variable in sql server, @@connections variable in sql server, find number of connections in sql server, get number of connections sql server, how to check number of connections in sql server, need of @@connections variable sql server, number of connections in sql server, number of connections in sql server 2000, number of connections in sql server 2005, number of connections in sql server 2008, number of connections in sql server 2012, number of connections in sql server database, sql server system variable @@connections, use of @@connections variable sql server, what is @@connections variableLeave a Comment on USING @@CONNECTIONS VARIABLE

Recent Posts

  • sp_xp_cmdshell_proxy_account – The provided account was invalid or the ##xp_cmdshell_proxy_account## credential could not be created Access is denied
  • Performance Tuning – Steps to make sure that you are comparing apples to apples
  • TSQL Script to fetch the list of tables with identity properties
  • TSQL Script to Clear SQL Server Cache
  • SQL SERVER 2016 Data Sheet

Recent Comments

  • Bitsqueezer on HOW TO CONVERT TABLE DATA TO XML AND XML TO TABLE
  • Matt on restore higher version database backup on lower version sql server – restore problem
  • Elisandro Lima Armindo on Causes For Network Related Errors in SQL Server
  • Dimssy on sp_MSforeachtable Examples – Uses – InDetail – msdn
  • sql1 on Conversion failed when converting the varchar value xx to data type int.

Archives

  • June 2018
  • August 2015
  • October 2013
  • September 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • January 2012
  • December 2011
  • August 2011
  • July 2011
  • June 2011

Categories

  • 10060
  • 10061
  • CHANGE DATA CAPTURE
  • Collations
  • Configuring SQL Server
  • Credentials
  • DatabaseBackup
  • DBCC Commands
  • Dead Lock
  • Dead Lock Resolution
  • Denali
  • Error Messages
  • Filtered index
  • Identity
  • Indexed Views
  • Interview Questions
  • Msg 10054
  • Msg 107
  • Msg 120
  • Msg 1205
  • Msg 121
  • Msg 127
  • Msg 141
  • Msg 15099
  • Msg 15122
  • Msg 15151
  • msg 15195
  • msg 15405
  • Msg 156
  • Msg 207
  • Msg 229
  • Msg 245
  • Msg 297
  • Msg 402
  • Msg 4606
  • Msg 4621
  • Msg 628
  • Msg 6401
  • Msg 7919
  • Msg 8152
  • Msg 8180
  • Nokia OVI Store
  • Performance Tuning
  • PROXIES
  • Puzzles
  • sp_executesql
  • SQL AZURE
  • SQL Date Time Functions
  • SQL Errors
  • SQL Security
  • SQL Server 2000
  • SQL Server 2008 R2
  • SQL Server 2010
  • SQL Server 2012
  • SQL Server 2016
  • SQL Server Abbrivations
  • SQL Server Basics
  • SQL Server Collations
  • SQL Server Download
  • SQL Server Installation
  • SQL Server Issues
  • SQL Server Links
  • SQL Server Management
  • SQL Server Misconceptions
  • SQL Server Permissions
  • SQL Server Profiler
  • SQL Server Tricks
  • SQL SERVER VARIABLES
  • SQLServerMaximumLimitations
  • SQLServerPedia Syndication
  • Stored Procedures
  • System Stored Procedures
  • T-SQL Code Examples
  • Table Variables
  • Temporary Tables
  • Tools
  • TOP Clause
  • VIEW CHANGE TRACKING
  • VIEW SERVER STATE
  • XML
Proudly powered by WordPress | Theme: ioboot by ioTheme.