470,815 Members | 1,340 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

Table lock

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.

Jul 23 '05 #1
1 1496
(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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Dr NoName | last post: by
11 posts views Thread by EoRaptor | last post: by
2 posts views Thread by John Bokma | last post: by
5 posts views Thread by Roger | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.