One thing I forgot to mention on my entry about the XML assembly is that CLR integration must be turned on the SQL server. To turn on CLR:
Connect to the SQL Server
Go to SQL Server 2005, Configuration Tools.
Go to the Surface Area Configuration/Surface Area Configuration for Features.
Click on the box to Enable CLR
(And while you are in there also enable the xp_cmdshell. You will probably need it later.)
No comments:
Post a Comment