Error "Lock request time out period exceeded" after executing a CREATE TABLE script and refreshing the Object Explorer (4307560)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "Lock request time out period exceeded" after executing a CREATE TABLE script and refreshing the Object Explorer
Description

The following error occurs after successfully executing a CREATE TABLE script and then manually refreshing the Object Explorer:
"Lock request time out period exceeded"
On checking in SQL Server Management Studio (SSMS) the table doesn't appear to have been created. Running the same script in SSMS creates the table successfully and can be seen in the Object Explorer
Cause

The AUTOCOMMIT switch for the editor was set to OFF
Resolution

Either turn on Autocommit, or click the Commit button after executing the script.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title