You can start SQL Server Profiler in several different ways to support gathering trace output in a variet ...
msdn.microsoft.com