Server.EnumLocks Method

Enumerates a list of current locks held on the instance of Microsoft SQL Server.

Remarks

Updated text:

Use this method to determine the locks that are currently held on the instance of SQL Server. The information that is returned can help you identify locking problems that might affect performance.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Overload List

Name Description
Server.EnumLocks ()
Enumerates a list of current locks held on the instance of Microsoft SQL Server.
Server.EnumLocks (Int32)
Enumerates a list of current locks held by the specified process on the instance of Microsoft SQL Server.

See Also

Reference

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

How to: Use an Enumeration Method that Returns a DataTable Object in Visual Basic .NET
Calling Methods
Managing Servers
sys.syslockinfo (Transact-SQL)

Change History

Release

History

New content:
  • Added code sample to the Example section.

  • Added to the description in the Remarks section.