Munnu ( XXXX@XXXXX.COM ) writes:
SQL Server offers the possibility to set a database in compatibility
mode, so that old syntax still works. However, your particular example
is not covered by the compatibility 65. (I just tried.) I have never
seen int(2) before, and I don't think this was ever documented or
supported in SQL6.5, it just happened to work.
To change the compatibility level of a database, you use sp_dbcmptlevel,
look in Books Online for details. However, I recommend that you fix
all syntax errors, so that you can use compatibility level 80 and use
SQL2000 at full strength.
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM
Books Online for SQL Server SP3 at