@@CONNECTIONS

Started by sukishan, Aug 19, 2009, 01:33 AM

previous topic - next topic
Go Down

sukishan

@@CONNECTIONS
Returns the number of connections, or attempted connections, since Microsoft® SQL Server™ was last started.

Syntax
@@CONNECTIONS

Return Types
integer

Remarks
Connections are different from users. Applications, for example, can open multiple connections to SQL Server without the user observing the connections.

To display a report containing several SQL Server statistics, including connection attempts, run sp_monitor.

Examples
This example shows the number of login attempts as of the current date and time.

SELECT GETDATE() AS 'Today''s Date and Time',
   @@CONNECTIONS AS 'Login Attempts'
Here is the result set:

Today's Date and Time              Login Attempts
---------------------------        ---------------
1998-04-09 14:28:46.940            18
A good beginning makes a good ending

dhoni

the connection program in sql server is login attempts

it can easily get this program

in the result the date,time and how have login attempts its easily to get details

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens Web Designing Chennai | GinGly :: Build your Personal Website | CineBuzz :: Cinema News | My Kids Diary :: Kids Memories Writing :: Book Website @ 349 Rs monthly
Copyright © 2005 - 2020 :: IT Acumens :: All Rights Reserved. :: Sitemap
ITAcumens Discussion Forum with 2 lakhs post running for 15 years - Powered by IT Acumens Dedicated Server