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.
Jul 30 @ 12pm EDT: A Checklist for Making Smart Technology Investments
Aug 5 @ 12pm EDT: From Spiraling Costs to Streamlined IT: The Journey to Invisible Infrastructure
Aug 11 @ 12pm EDT: How to Detect SQL Injection & XSS Attacks with AlienVault USM
Aug 19 @ 12pm EDT: Small Business: Assess Your Technology to Ensure Your Operation Isn’t at Risk
View the complete online training catalog
Tweets about @WindowsITPro
To submit an article, please log in and then click Contribute. If you are not a registered user on Windows IT Pro, click Register.
All Sponsored Blogs
The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.
Sponsored Introduction Continue on to (or wait seconds) ×