CODEWITHSUNDEEP
sql-serverreporting-servicessql-server-profiler
Moe Sisko
Moe Sisko

Reputation: 12005

SQL Server Profiler : capture calls to your database's stored procs during SSRS report generation

Using SQL Server/SSRS 2008.

With SQL Server Profiler, I've been unsuccessfully trying to trace SSRS (rdl) report generation calls to my database's stored procs i.e. so I can see what parameter values are being passed etc.

What events should I be looking for?

Upvotes: 6

Views: 10823

Answers (1)

Oleg Dok
Oleg Dok

Reputation: 21756

Events:

In Stored Procedures group

  • RPC:Completed
  • RPC:Starting (if completed is not called because of error in proc)

If your proc is called as usual Sql Query, then:

In TSQL group

  • SQL: Batch Starting
  • SQL: Batch Completed

Upvotes: 10

Related Questions