So, building on my previous blog entry, now, let’s open a multi-server query and run this script that follows. It will tell you for each server it’s version and how much memory is in locked pages.
Month: February 2012
Programmatically act on SQL Version
I often have scripts that run across multiple versions of SQL … more and more 2008’s and less and less 2000’s. In doing so, i need to take different actions based on that version. Here’s the simple technique that i…