|  | Posted by Tom Moreau on 06/14/72 11:37 
You've really told us nothing here.  Have you determined if there is a blocked process?  what happens if you run sp_who?
 
 --
 Tom
 
 ----------------------------------------------------
 Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
 SQL Server MVP
 Columnist, SQL Server Professional
 Toronto, ON   Canada
 www.pinpub.com
 
 "VU2LOC" <vu2loc@gmail.com> wrote in message
 news:1137493777.837548.11200@g47g2000cwa.googlegroups.com...
 Well I am the MS-SQL user I always face the problem in my application.
 After some time my application stop working goes in to the not
 responding stage. Then I have to KILL some session which are SPID > 51.
 
 After this my problem is getting resolved after this I can able to
 create new sessions. Please help me ot with this issues.
 
 regards,
 
 Shailesh
  Navigation: [Reply to this message] |