Thanks for the confirmation I did read that 2gb is allowed. We found out that our WCF service is failing it is configured for a high volume of data but...

Sorry , guys ... I was trying to connect to the server and had the ODBC on my machine i.e the client instead of the server just did it on...

Yes i have installed ODBC MySQL driver 5.1.8 but the issue was I was not able to find any documentation on this new version of the driver and hence the...

it is 32 Bit

SQL Server 2008 R2

add an insert trigger on the table where you want the event to be detected.

Thanks I tired it with the type keyword and tried to cast the string as xml type

But the query gave an error as

"The xml data type cannot be selected...