DF215: Locking hint is used.

Last modified: May 28, 2025

The topic describes the DF215 T-SQL code analysis rule.

Message

Locking hint is used.

Locking hints should be used with caution. Please review the query.

The rule is applied to:

SELECT id FROM dbo.DemoTable WITH(TABLOCKX)
GO

SELECT id FROM dbo.DemoTable
GO

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.