Results 1 to 3 of 3

Thread: SQL Server Logs

  1. 11-09-2006, 10:32 AM #1
    bobkand
    bobkand is offline Registered User
    Join Date
    Sep 2005
    Posts
    43

    Angry SQL Server Logs

    Is there any way we can log in the info like this in SQL Server

    Who logged in
    What date
    OS Name
    Ipaddress
    SQL Login Name
    Reply With Quote Reply With Quote
  2. 11-09-2006, 10:52 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Security auditing can be done by server level trace or through profiler.

    Look into BOL for
    sp_trace_setevent
    sp_trace_setfilter
    sp_trace_create
    sp_trace_setstatus
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 11-09-2006, 03:10 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Or enable sql auditing, will get most of you are looking for.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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