Table lock

[tawfiq.choudhury]

Hi,

If I run an insert statement from the query analyzer and then try to
open the table from enterprise manager then it takes long time to open
the table. But this problem dissapears when i put the statement inside
Begin/End Transaction statement.

Any idea why this is happening?

Thank in advance.
Taw.

[Erland Sommarskog]

(ta**************@grameenphone.com) writes:

If I run an insert statement from the query analyzer and then try to
open the table from enterprise manager then it takes long time to open
the table. But this problem dissapears when i put the statement inside
Begin/End Transaction statement.

Any idea why this is happening?

The one thing I can think of is that you have implicit transactions on.
You can check this with DBCC USEROPTIONS.

Under Tools->Options->Connection you can control which SET options that
are set when you connect.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp