I'm running the following statement, it is working locally with SQL Server 2008, however, there is SQL Server 2008 Express on the development server, and after the sql statement runs, I am unable to do SELECT statements on the table in which I deleted the record. Both databases were created with the same table creation scripts.

"DELETE FROM [dbo].[tblMiddayMover] WITH (ROWLOCK)  WHERE [idMiddayMover] = @IdMiddayMover"

What reasons would this statement ever cause the database to hang.

After executing that statement, the following SELECT statement causes an error.

"SELECT * FROM [dbo].[tblMiddayMover] WHERE [fldActive] = 1"

I get the following error:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I can do select statements on any other table with no issues.