Enterprise Manager Slow To Release Locks

Why not join our community?, there are 15 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

1
kicks

kick it

Enterprise Manager Slow To Release Locks

submitted by captainvere 1 year, 9 months ago

— I discovered today that SQL Server Enterprise Manager creates table and row locks from SELECT queries when the result-set has more records than the result pane has room. These locks will persist until you 1) scroll through to the end of the result-set, or 2) close the query window. Why is there not a louder warning regarding this? Why does the SQL Server Manager product name include the word "Enterprise"?!!

1 comment | category:

Database | Views: 1 | Get KickIt image code

tags: ASP.NET | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

captainvere

Comments:

I apologize for leaving out a link to some discussion on the microsoft-public-sqlserver-clients Usenet group:

http://www.dbtalk.net/microsoft-public-sqlserver-clients/select-rows-database-lock-150405.html

posted by captainvere 1 year, 9 months ago