DF200: A table hint without WITH keyword is used.

Last modified: July 9, 2025

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

Message

A table hint without WITH keyword is used.

It is recommended to specify hints using the WITH keyword, as SQL Server 2005 doesn’t support multiple hints in a T-SQL statement without it.

SELECT id FROM dbo.DemoTable (TABLOCK)
GO

SELECT id FROM dbo.DemoTable WITH(TABLOCK)
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.