Just Learned from Tony Rogerson's blog "How to make a table Read Only in SQL Server". It would be making the file group read only because another benefit of that is that SQL Server doesn’t have to issue locks. [code] USE [master] GO ALTER DATABASE...

Just Learned from Tony Rogerson's blog "How to make a table Read Only in SQL Server". It would be making the file group read only because another benefit of that is that SQL Server doesn’t have to issue locks. [code] USE [master] GO ALTER DATABASE...

I liked this one. Instead of doing a complicated sql query I would rather flatten de xml first using xquery: SET @x = @x.query(' for $blogger in /bloggers/name return element blogger { attribute id {$blogger/@bl...