Getting SQL Server registry settings via SQLCLR table-valued user-defined function...
Posted by: SQL Server Engine Tips,
on 19 Aug 2005 |
View original | Bookmarked: 0 time(s)
SQL Server stores several configuration values like data path root, program directory, default domain etc in the registry. These values can be obtained by using the SMO Settings object but you can use it only from the client side. SMO is alo not supported in SQLCLR so it is not possible to leverage the functionality on server-side directly. So if you want to obtain the settings from TSQL then it is difficult to do. This problem comes up quite often in the newsgroups and the solutions using undocumented...