Table List: Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

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.
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

1 comments:

Anonymous said...

When performing the query the result is returned in a bunch of records, so how did you actually identify the locking process??