sql profiler trace what happens if a query did not complete
let sql porfiler trace half hour. query started during time did not complete. show in trace? hi prem, it's depend on events have captured\selected while configuring profiler trace. example if running 1 query "select * table" , in profiler trace , if checked sql:batchstarting after if cancel query in case you should able see query. , if selected sql:batchcompleted in case see same query @ 2 places regards, vikas rana vikas rana SQL Server > SQL Server Setup & Upgrade