>BTW, correct me if I am wrong but is it possible With Values only exists since SQL Server 2008? I just ran that code against a SQL Server 2005 and it generated an error.
The syntax is valid in SQL Server 2005
SQL Server 2005 Alter Table BOL referenceThe same sample H exists there.
If it's not broken, fix it until it is.
My Blog