RE: err

From: Ram Kumar Koditala (RamKumarKoditala_at_discussions.microsoft.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 10:53:04 -0800

See any process is locking any others
use
exec sp_who2 and look for BlkBy column

Thanks
RK

"shif" wrote:

> Hi
> I am having an application with mssql7 standard as backend.
> Some times the entry screen is hanging and nobody can save data.
> I am using several mster tables like supplier,customer..etc
> At this time when i start opening a table ex:supplr_master in server
> it is showing an error
> "Microsoft odbc sql server driver Timeout Expired",
> and sometime i noted this error also, "Data provider or other service
> returned an E-fail status.
> How can i solve this problems
> please help
> --
> Thanks