I'm no expert, but have seen many posts regarding this one. If you simply want an indication of whether it's used a trace with SQL profiler is a simple option.

You...