sql server mseq: err -- sql server mseq

err	shif 2/10/2005 1:43:07 AM

sql server mseq:

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
--

RE: err

Ram Kumar Koditala
2/10/2005 10:53:04 AM

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

Thanks
RK

[quoted text, click to view]

RE: err

shif
2/12/2005 7:57:04 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.