SQL Server Function … and two hours of my life

Actually this is kind of same issue that I blogged about way back in last year.  At that time it was all about view, but I didn’t knew that same limitation exists for functions (aka UDF) as well. Exactly like view, in function also when one function (child function) is calling another function (parent function)

Solving MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{8BDD006D-D5F0-4AAA-BA13-65995063EC44}’. Error code: 1608

Today I got call from one of my friend for help in installing SQL Server 2008 R2. Apparently, he somehow cancelled the installation at very beginning of process for some reason and then every single attempt to install it again failed with really weird error. To resolve this problem, we removed registry entries leftover, removed