I spent 5 mins looking for the .NET type SqlHierarchyId today so I thought I'd share (it's probably very obvious but not so obvious that I actually knew). It seems to live in; Microsoft.SqlServer.Types.dll which, for me, lives in c:\program files\Microsoft
Read More