Solved

10775: audit the execution of store

Posted on 2014-11-23
3
160 Views
Last Modified: 2014-11-24
Dear Experts,
I have the following scenario.

Database users have execute permissions are, what you want is to audit the execution of store (EXEC or EXECUTE) when Toad is performed through, management studio or another IDE.

I thank you in advance for your time.
0
Comment
Question by:enrique_aeo
  • 2
3 Comments
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 40461589
Run a SQL Server Profiler and configure it to trace Stored Procedure calls.
0
 

Author Comment

by:enrique_aeo
ID: 40461943
Can you give me more detail please (step by step)
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40462169
Open the SLQ Server Profiler, create new trace and check the stored procedure events are:
RPC: Completed
SP: Completed
SP: Completed
Click on Run and let it collect data until you want to stop the trace.

For further and more detailed information please check the MSDN article.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now