(tawfiq.choudhury@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, esquel@sommarskog.se

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