Which Version of Commerce Server Database I have?

ravikanth | December 24, 2008

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
Categories
commerce server 2007
Comments rss
Comments rss
Trackback
Trackback

« Error while executing OrderMapping.Exe tool Unrecognized attribute ‘language’. Note that attribute names are case-sensitive »

Leave a Reply

Powered by WP Hashcash