Search code examples
sqlsql-serversqlcmd

SQLCMD Mode - Incorrect Syntax?

Trying to use:

:On Error exit

:r D:\opt\db_objects\REPORTS\dbo.sp_ReportCountLORUsers.sql

...and I get:

Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'U'. ** An error was encountered during execution of batch. Exiting.

What am I missing?

Solution

  • Perhaps a syntax error in dbo.sp_ReportCountLORUsers.sql ?