Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sitapati
Starting Member
1 Post |
 Posted - 2013-01-29 : 10:50:06
|
| SELECT GETDATE() AS 'Today''s Date and Time', @@CONNECTIONS AS 'Login Attempts'shows 72624361How accurate is this data? Is it really SQL Server login (success/failure) attemptsI 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
5072 Posts |
Posted - 2013-01-29 : 11:19:54
|
| http://technet.microsoft.com/en-us/library/ms188915.aspx |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-30 : 08:38:55
|
| 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 connectionsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
@@CONNECTIONS numbers