Solved

10775: audit the execution of store

Posted on 2014-11-23
3
171 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

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 50

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

751 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