Last post Sep 23, 2008 09:04 AM by ksridharbabuus
Sep 20, 2008 06:11 PM|sparrow37|LINK
where b_spid=spid AND b_cpu=cpu AND b_physical_io=physical_io AND b_last_batch=last_batch'
where o_spid=spid AND o_cpu=cpu AND o_physical_io=physical_io AND o_last_batch=last_batch'
it executes infinetly and not sure what it does in background. any ideas ?
Sep 23, 2008 07:06 AM|Jian Kang - MSFT|LINK
I think SQL Server Profiler can help us to make sure what the stored procedure does, which captures data about each event. It allows us to see exactly what Transact-SQL statements or Multi-Dimensional Expressions are submitted to the server.
For more information, please refer to the links below:
Using SQL Server Profiler
Sep 23, 2008 09:04 AM|ksridharbabuus|LINK
In the first procedure there is while loop "WHILE 1=1" is always true. Because of this it is going into infinite loop.