SharePoint Tip #16. Do you know “how to get the SharePoint version programmatically”?

re: SharePoint Tip #16. Do you know “how to get the SharePoint version programmatically”?

Jen — Wed, 05 Aug 2009 09:08:51 GMT

or something like this (when I'm checking if SP2 is installed), which is a bit smaller:

Version version = SPFarm.Local.BuildVersion;

bool sp2 = (version.Major >= 12 && version.MinorRevision >= 6421);

Dzeee — Wed, 22 Apr 2009 01:29:41 GMT

Interesting post on how to find the versions of SharePoint installed in the farm.

Jay — Wed, 15 Apr 2009 20:04:33 GMT

fzchen: It sounds like you didn't select the correct database. Try the following:

Replace with your ID (do exec sp_databases to figure out the name)

use "SharePoint_AdminContent_c2150d26-7bd4-4a06-9437-fde2496ccb02";

select Version,UserName from Versions where VersionID='00000000-0000-0000-0000-000000000000' order by id desc;

Jason Kuter — Wed, 15 Apr 2009 17:12:38 GMT

I believe its here:

Michael — Mon, 13 Apr 2009 08:29:18 GMT

What code did you use?! SQL or API?!

fzchen — Mon, 13 Apr 2009 08:17:43 GMT

I really want to know "how to get the SharePoint Farm server's version programmatically",I try to get it user sql script but I got nothing.