Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

sql2005 session id keep being blocked bt the same session id

Posted on 2010-01-11
2
Medium Priority
?
339 Views
Last Modified: 2012-05-08
Hi,
In sql2005 I keep encountered blocking whereby the spid being blocked by himself, I have reindiex the database and recompile all the sp but it look never resolved the problem, any hint on this issues?
0
Comment
Question by:motioneye
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 1000 total points
ID: 26284770
0
 
LVL 17

Assisted Solution

by:k_murli_krishna
k_murli_krishna earned 1000 total points
ID: 26284833
Getting Blocking Info In SQL Server 2005 & 2008 the easy way
http://blogs.microsoft.co.il/blogs/dannyr/archive/2008/10/07/getting-blocking-info-in-sql-server-2005-amp-2008-the-easy-way.aspx
Understanding and resolving SQL Server blocking problems
http://support.microsoft.com/kb/224453
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question