Reproducing Problems
In general, the time it takes for your primary support provider to resolve a problem is reduced if you generate a reproducible test case demonstrating the error. These test cases can range from a single query that is not acting as expected to a relatively complex code fragment that encounters a serious problem. A quick resolution is more likely when the test case is simple.
Important Providing a test case improves the chances of a quick resolution to the problem. If a problem cannot be reproduced, it is usually impossible to solve.
Whenever possible, create the test case using the pubs or Northwind sample databases. In many cases, creating a test case can save you from having to send large amounts of data to your primary support provider.
To reproduce and diagnose problems, SQL Profiler may be used. SQL Profiler captures information about events and, if necessary, replays these events. Capturing and replaying events can be instrumental in reproducing and diagnosing problems.