SQL Server 2005 -Seeing SPs executing inside SPs...

How to find timed out statements in SQL 2005 profiler...

Is there an alternative to the SQL Profiler for SQL Server 2000...