A. Usual reason for this is that the command only works on SQL 7 mode databases. If you have migrated an existing 6.5 database then it is probably still set to 6.5 compatibility mode. Use sp_dbcmptlevel to check and set it to SQL 7 mode.
* Key Features of Active Directory for every version of Server OS, including Windows Server 2012 R2 and Windows Server 2016 * Key elements of Microsoft System Center 2012 and System Center 2012 R2 PLUS major changes in the 2016 wave * Deploying, Migrating to, and Managing Hyper-V in Your Organization * Implementing a Private Cloud * Using PowerShell to Automate Common tasks * Key Windows 10 changes including the new Start menu, Cortana, Microsoft Edge, and more * And much more!