I ran across this issue at work. When passing a boolean value in the form of true/false and not 1/0 in an XML string to SQL Server, SQL Server 2000 doesn't have the ability to convert true to 1 and false to 0. This is not the case with SQL Server 2005. The solution is to either convert true to 1 and...

Continue reading "XML strings and boolean values in SQL Server 2000"