Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to report on failed login attempts to SQL Server 2008 Database
- Thread starter dgillz
- Start date
This will read the current log file:
EXEC sp_readerrorlog 0,1,'login failed'
You can add a command to the report and place this line there
Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.
EXEC sp_readerrorlog 0,1,'login failed'
You can add a command to the report and place this line there
Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.
- Thread starter
- #3
Where is this sp located? It does bot return enough data, and I'd like to modify it.
Software Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
Software Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question