SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 @@CONNECTIONS numbers		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sitapati
Starting Member

USA
1 Posts
Posted - 01/29/2013 :  10:50:06  Show Profile  Reply with Quote
SELECT GETDATE() AS 'Today''s Date and Time',
@@CONNECTIONS AS 'Login Attempts'

shows

72624361

How accurate is this data? Is it really SQL Server login (success/failure) attempts
I use sql-server connected through ADO.NET only(99%)

1. direct login to website sqlserver and +
2..NET ADO.NET connection

This is my website sql-server shows this data.

Can anyone explains ?what is this all about.

russell
Pyro-ma-ni-yak

USA
4993 Posts
Posted - 01/29/2013 :  11:19:54  Show Profile  Visit russell's Homepage  Reply with Quote
http://technet.microsoft.com/en-us/library/ms188915.aspx
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1773 Posts
Posted - 01/30/2013 :  08:38:55  Show Profile  Visit jackv's Homepage  Reply with Quote
According to BOL : Returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started.

Keep in mind a user can make multiple connections

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000