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"?!!