SQLTeam.com | Weblogs | Forums

SQL Server 2012 Log: Incorrect syntax near the keyword 'with'

sql2012

#1

Hi

I am using SQL Server 2012. In it's log, it reports the following error every 20 seconds:

Source:spid24s

Message:
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

According to the error message, I have no way to find out which procedure/function has the syntax problem above. Can anybody help me how to fix this problem?

Thanks
Neil


#2

Use SQL Profiler with a filter on "with" ?


#3

can you check the output using this

DBCC INPUTBUFFER(24)