2 Kicks

Enterprise Manager Slow To Release Locks()

submitted by captainverecaptainvere(45) 3 years, 8 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"?!!

2 comments |category: | Views: 8

tags: another

new 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:
captainverecaptainvere(45) - micle77micle77(290)

Comments:

posted by captainverecaptainvere(45) 3 years, 8 months ago 0

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

Reply

posted by migrainexemigrainexe(1) 29 days, 15 hours ago 0

http://reviewsblackberry.com/

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?