Is there a way to find out which table in a database has xml data type columns? and also is it possible to search these fields for a string? thanks
SELECT OBJECT_NAME(c.object_id), c.name FROM sys.columns c INNER JOIN sys.types t ON c.user_type_id = t.user_type_id WHERE t.name = 'xml' Roji. P. Thomas http://toponewithties.blogspot.com