Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

10775: audit the execution of store

Posted on 2014-11-23
3
Medium Priority
?
191 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 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 2000 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 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

824 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