-
SQL EM sharelocking table when "return all rows¡±
SQL Server 2000, Enterprise manager=>highlight a table=> right click=>¡°Open table¡±=>"return all rows¡±
This will lock the table as long as the table content window is open.
This is harmful as developers tend to use this handy tool to view data in production server and block end users sometimes.
SQL 7 does not have this problem.
Any easy solution? (w/o going back to SQL 7
Jonathan, Senior DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|