Profiler

External Article

Testing with Profiler Custom Events and Database Snapshots

  • Article

We've all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they're so complex and have so many logic offshoots that it's very easy to get lost when you're trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code.

2009-07-15

2,305 reads

Blogs

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Data is not immutable

By

Information — in the form of data — usually stored as binary 1s and...

Daily Coping 25 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Server Data Discovery and Classification - times out...

By cphite

The powers that be have commanded that we implement data classification because...  well, to...

How to Navigate through folders to find .zip file

By mcfarlandparkway

Is there any script task in SSIS to find the zip files under each...

Indexing

By bobrooney.81

Hi All, How to tell if the index is useful for my reads or...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers