Blocking (Urgent)

[Lara]

Hello,

In the morning at 9:32 one of the spid was blocked and got time out msg for select statement. the statement was sp_execute wht is sp_execute?
can anyone guide me?

Thanks

[Ram]

Lara,
execute sp_who2 and find which spid is blocking and execute DBCC inputbuffer(spid).Kill spid

good luck
ram

------------
Lara at 7/10/01 10:50:40 AM

Hello,

In the morning at 9:32 one of the spid was blocked and got time out msg for select statement. the statement was sp_execute wht is sp_execute?
can anyone guide me?

Thanks

[Anu]

Hi,

sp_execute is the command used by sqlserver and this will be executed when there is an access violation occurs when the application is connected to the database thru odbc or oledb . check the error log if you got any error at that time

-Anu

------------
Ram at 7/10/01 1:22:20 PM


Lara,
execute sp_who2 and find which spid is blocking and execute DBCC inputbuffer(spid).Kill spid

good luck
ram

------------
Lara at 7/10/01 10:50:40 AM

Hello,

In the morning at 9:32 one of the spid was blocked and got time out msg for select statement. the statement was sp_execute wht is sp_execute?
can anyone guide me?

Thanks