-
Login information
Hi,
Can we retrieve the Login Failed and succedded for SQL Server?
I want to know the login failed and succedded information of SQL Server.
Can we retrieve the same?
Let me know ASAP.
Thanks and Regards,
Pramod
-
open enterprise manager, right click on your server, on the security tab select the Audit level option that you want out of none, failure, success or all.
FatherJack
-
The loggin information is written to error log. You can use xp_readerrorlog to read the content in a table format, then search for success or failed string.
-
Thanks for the help,
Since the current active log file is locked by SQL Server, does xp_readerrorlog file returns the current values?
Thanks and Regards,
Pramod.
-
Yes, and you can open sql server log file with any text editor.
-
Yes xp_readerrorlog reads current file, if you want to read older log you can pass the errorlog number
xp_readerrorlog 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|