What kind of lock does SQL Server 2008 R2 acquires when doing DBCC SHRINKDATABASE?

What kind of lock does SQL Server 2008 R2 acquires when doing DBCC SHRINKDATABASE?  Thanks.
thomaszhwangAsked:
Who is Participating?
 
dmarinenkoConnect With a Mentor Commented:
Table Locking, the same as if Tablock was used.  By the way, shrinking a 2008 database is normally not recommended,
http://msdn.microsoft.com/en-us/library/ms188796.aspx

One reason it isn't recommended
http://www.mssqltips.com/sqlservertip/2055/issues-with-running-dbcc-shrinkfile-on-your-sql-server-data-files/
0
 
thomaszhwangAuthor Commented:
Thanks.
0
All Courses

From novice to tech pro — start learning today.