This is REALLY weird. I'm running '14 Developer's Edition on my desktop and I can't do a select * from sys.configurations. The system comes up and says "Incorrect syntax near 'sys'." I run it from my laptop and I get 70 rows of output. Both computers are running Win 7 Pro x64 and are fully patched.
Thus, I can't run Dennis' code from my desktop. I'll try it against my VM production server later this afternoon.
*sigh* Never mind. PEBKAC error. 😀
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]