-
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
-
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
-
Or enable sql auditing, will get most of you are looking for.
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
|
|