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.
Join John Savill for 9 hours of comprehensive PowerShell training. This course will start from the ground up, walking through the basics of PowerShell, how to create basic scripts, and building toward creating custom modules to achieve amazing results in your environment, in non-Microsoft environments, and in Azure.