1

Closed

incorrect UPDATE statement for [SET_AX_SQLTRACE]

description

For OFF, there is a typo in the UPDATE statement, resulting in error:

Msg 102, Level 15, State 1, Line 29
Incorrect syntax near '&'.
    IF @TRACE_STATUS = 'OFF'
      BEGIN
          IF @AX_ID IS NULL
            SET @SQL = 'UPDATE [' +@SERVER_NAME + '].[' + @DATABASE_NAME + '].dbo.USERINFO
                SET QUERYTIMELIMIT = 0,
                    DEBUGINFO = DEBUGINFO & 2147483391,
                    TRACEINFO & 2147481599'
Last part should be:
                SET QUERYTIMELIMIT = 0,
                    DEBUGINFO = DEBUGINFO & 2147483391,
                    TRACEINFO = TRACEINFO & 2147481599'
Closed Mar 15 at 9:29 PM by RodHansen
Fixed in Mar 2017 patch

comments

RodHansen wrote Mar 15 at 9:29 PM

Fixed in upcoming patch

wrote Mar 15 at 9:29 PM