crussell (6/17/2009)
I tested it on an existing test database table and immediately got an error because I had a trigger on the table. Using a table without a trigger gave me the kind of results intended.
There also can't be any CHECK constaints on the table, and it can't be either end of a FOREIGN KEY relationship.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi