Just installed slq server 2008 express on my local machine (vista home premium sp2) have latest .net framework installed. I cannot get a query in tsql to recognize any of the methods associated with hierarchyid such as GetRoot(), GetDescendent(),
etc. What do I need to do to be able to access these functions? I have executed sp_configure to enable clr.
View Complete Post