Share via

The SQL Server Fails to Accept a Value Change While SQL Debugging

  • Article

Feature Only in Enterprise Edition   This feature is supported only in Visual C++ Enterprise Edition. For more information, see .

The SQL debugger's watch window will accept values greater than the variable's declared limit, but SQL server adheres to the size limit and truncates the value. For example, if you declare a variable as follows:

@name varchar(30)

and then use the watch window to change name to a value that is longer (such as 35 characters), the debugger will accept the value but truncate the extra five high-order characters.