When browsing the table list within SQL Server Management Studio, I received this error:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&
EvtSrc=MSSQLServer&EvtID=1222&LinkId=20476
I didn't found any error when I checked locked processes with:
SELECT * FROM SYSPROCESSES WHERE BLOCKED <> 0
After some minutes I realized that processes could not be found because Management Studio timed it out after 5 seconds.
So I decided to manually query the list of tables with:
SELECT * FROM SYSOBJECTS
It remain blocked and querying sysprocesses I was able to find the blocking process and kill it.
- Blogger Comment
- Facebook Comment
Subscribe to:
Post Comments
(
Atom
)
1 commenti:
When performing the query the result is returned in a bunch of records, so how did you actually identify the locking process??
Post a Comment