MS SQL Server - Lock request

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Lock request

cbrichards via SQLMonster.com

2006-11-09, 7:14 pm

I was wondering...I have a select statement that inserts into a Temporary
Table. From my understanding, the select statement should not be locking any
of the tables used in the select statement, because the lock request on a
select statement is Shared(S).

Or, because the select statement is used to perform an insert, does it
generate a different lock request?

Please clarify.

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200611/1

Sponsored Links