Geeks With Blogs

@mikedopp
  • mikedopp space heater at full blast and still just enough to keep the keyboard defrosted. Ah spring to summer transition. about 484 days ago
  • mikedopp favorite google search of the day [filetype:xls confidential] find out salaries of your favorite people. about 490 days ago
  • mikedopp enjoying the multi-window update fer my S3 :) about 490 days ago

News

mikedopp Geekswithblogs (edition)

To those whom love Commerce Server 2007 as much as I do. Here is a little script to help you determine the Service Pack level of each database.

use MSCS_Admin
select s_PropertyName, s_Value
From dbo.resourceProps

This will return multiple values. This is helpful in knowing if you have Commerce Server 2007 installed correctly as well as helping you to identify the correct service pack upgrade number per database.

SP1

Transaction Database = 7.0

Transaction Config Database = 7.0

Product Catalog Database = 7.2

Inventory Database = 7.1

Direct Mailer Database = 6.0

 

SP2

Transaction Database = 7.1

Transaction Config Database = 7.1

Product Catalog Database = 7.3

Inventory Database = 7.2

Direct Mailer Database = 6.0

 

Enjoy!

 

Digg This
Posted on Tuesday, May 19, 2009 11:36 AM | Back to top


Comments on this post: Commerce Server 2007: Determine the Service Pack (Lookup Script)

No comments posted yet.
Your comment:
 (will show your gravatar)
 


Copyright © mikedopp | Powered by: GeeksWithBlogs.net | Join free