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. Continue reading “Determine “Locked Paged” use across your domain…”
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 have developed … it currently depends on Microsoft continueing to use periods in their version naming scheme… i don’t think that that will change soon!
select ltrim(substring(@@version,CHARINDEX(‘.’,@@version)-2,2))
Steve