RE: err

From: shif (ns_0001_at_hotmail.com)
Date: 02/12/05 

Date: Sat, 12 Feb 2005 07:57:04 -0800

Sir
Actualy i am new in mssql7,i have noted the result through sp_who2 at the
same time of this problm.the result is
SPID Status Login HostName BlkBy DBName
Command
16 sleeping sa . 9 acc SELECT
   
2 BACKGROUND sa . . acc LOCK MONITOR
    
3 sleeping sa . . acc LOG WRITER
   
4 BACKGROUND sa . . acc LAZY WRITER
    
5 sleeping sa . . acc CHECKPOINT
SLEEP
6 BACKGROUND sa . . acc AWAITING
COMMAND
suppose if any locking happen in any table ,how can i solve this.
please help
thanks

"Ram Kumar Koditala" wrote:

> 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

Relevant Pages