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.
In this interactive online training event SharePoint MVP Randy Williams shows you how your users can benefit from Microsoft's latest reporting technologies and how you can better manage the challenges of BI and SharePoint.