http://snippets.dzone.com/posts Fri, 29 Aug 2008 04:01:10 GMT DZone Snippets: Klumsy's Code Snippets http://snippets.dzone.com/posts/show/1571 // part of a sql server CLR function, and example of hosting MSH in sql server 2005 <br /><code> <br /> [Microsoft.SqlServer.Server.SqlFunction] <br /> public static SqlString sqlmsh(string input) <br /> { <br /> string output; <br /> Runspace runspace = RunspaceFactory.CreateRunspace(); <br /> runspace.Open(); <br /> Pipeline pipeline = runspace.CreatePipeline(input); <br /> MshObject myobj = pipeline.Invoke()[0]; <br /> if (myobj.BaseObject is XmlDocument) <br /> { <br /> output = (myobj.BaseObject as XmlDocument).InnerXml; <br /> } else <br /> output = myobj.ImmediateBaseObject.ToString(); <br /> <br /> runspace.Close(); <br /> return new SqlString(output); <br /> } <br /></code> Sat, 25 Feb 2006 06:31:44 GMT http://snippets.dzone.com/posts/show/1571 klumsy (karl prosser)