Which Version of Commerce Server Database I have?

December 24, 2008 |

Author ravikanth

The database version will change whenever the site is upgraded to new version or patch. To know, which version of database you are having, you can run below query on MSCS_Admin database.

Select Resources.s_DisplayName, List.* from
( SELECT SR.[i_ResourceID],
        sites.s_Name
      ,[s_PropertyName]
      ,[i_Vartype]
      ,[s_Value]
FROM ResourceProps RP, SiteResources SR, Sites
Where RP.[i_ResourceID]= SR.[i_ResourceID]
and SR.i_SiteID = Sites.i_SiteID
and s_PropertyName like ‘%version%’ ) list, Resources
where list.i_ResourceID = Resources.i_ResourceID

Customer and order manager crashes with 102 error
commerce server 2007 supports ends on 12th July
How to Reset virtual catalog product price
Troubleshoot– error occurred when configuring Marketing direct mailer
Get Connection strings from commerce context

If you like this post, please click on our sponsor advertisement.

Posted in commerce server 2007

Commerce Server Blog

Which Version of Commerce Server Database I have?

Related Articles

Leave a Reply