The new procedure works really great for SQL 2012+, however doesn’t have backward compatibility (as the author warned, he/she didn’t test it with earlier versions). Unfortunately, for today’s date, Chrissy’s script is a bit outdated, as HawkmanAZ pointed out in commend, as suggested a new decoding procedure. The script is really universal, as it’s browsing registry scanning for all installed instances and do a wildcard search for older versions. Reading comments to these posts, I found a link to a brilliant script by Chrissy LeMaire in MS Script Center here. Forgot to mention: I need a really universal solution working with SQL from 2005 to SQL 2017. ![]() Both scripts have improvements for SQL Server 2012, but still not universal. Next to that come posts by Ryan on 17th of October 2015 and Xian Wang’s one on 22nd of June 2013. The post has lots of comments and some updated scripts suggested by visitors. His script is locked to SQL Server 2008 and not looking for multi-instance installations. The very first solution seem to be in Jakob Bindslet’s post on 11th of November 2010. But it was new for me, so I started googling. ![]() ![]() The task, probably, appeared withe the very first deployment of SQL Server, or a bit later, when its CD box was lost. OK, this task is not accidental in general.
0 Comments
Leave a Reply. |