Solved

What is the version of SharePoint?

Posted on 2014-11-20
4
242 Views
Last Modified: 2014-11-20
I have a set of SQL databases from a SharePoint environment.  I do not have any of the web files.

I am trying to determine the version of the SharePoint database.  Does anyone know how to write a SQL query to do this?
0
Comment
Question by:rye004
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 250 total points
ID: 40455700
select * FROM [SharePoint_Config].[dbo].[Versions]
WHERE VersionId = '00000000-0000-0000-0000-000000000000'

Then look up the version in http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=346
0
 
LVL 20

Assisted Solution

by:dsacker
dsacker earned 250 total points
ID: 40455715
This query should work. If your Sharepoint database name is not "Sharepoint_Config", select the appropriately named config database.
SELECT VersionId,
       Version,
       Id,
       UserName,
       [TimeStamp],
       FinalizeTimeStamp,
       Mode,
       ModeStack,
       Updates
       Notes
FROM   Sharepoint_Config.dbo.Versions
WHERE  VersionId = '00000000-0000-0000-0000-000000000000'
ORDER BY Id DESC

Open in new window

The first record will be your most current version (if they have changed).
0
 

Author Comment

by:rye004
ID: 40455758
Thank you guys.  I am getting version 14.0.4762.1000, which I believe is SharePoint 2010.  Could someone confirm this?
0
 
LVL 20

Expert Comment

by:dsacker
ID: 40455763
Yes, it is 2010 RTM.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL LINE CONTINUATION ISSUE 12 33
Trying to get a Linked Server to Oracle DB working 21 59
cannot connect to sqlserver 8 27
Deal with apostrophe in stored procedures 8 42
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question