Category Archives: Work

Fixing “Value does not fall within the expected range” error in MOSS page settings

I wrote this script to correct the error I got from MOSS when trying to edit page settings. Our site uses an internal url (wwwint.mysite.com) and an external one (www.mysite.com). The page layout seemed to have been reset to use … Continue reading

Posted in Work | Tagged | Leave a comment

Avoiding X.509 chain policy caching when using WCF with certificate security

A while ago my customer came to me with an issue that was a bit tricky to find a solution to. Their system uses a Windows forms client and a WCF service running on IIS7 on a Windows 2008 R2 … Continue reading

Posted in Work | Tagged , , , | 3 Comments

Field not found: CatalogResourceMajorVersion from Commerce Server 2007

So I was trying to troubleshoot this Biztalk 2006 R2 orchestration that includes importing some data into a Commerce Server 2007 instance. CS doesn’t really want to play ball, so I decide to upgrade it to the latest service pack … Continue reading

Posted in Work | Tagged | 1 Comment

NULL values in SOAP requests

Question: how to pass a NULL value in a SOAP envelope? Answer: Use the xsi:nil=”true” attribute on the element, and don’t forget the xsi namespace in the envelope. Example SOAP request:

Posted in Work | Tagged , , , | Leave a comment

Listing subcategories for a category in Commerce Server 2007 using a SQL query

As promised, here is the follow-up to the last post. This query gets us the names of all subcategories of a particular category in Commerce Server 2007.

Posted in Work | Tagged , | Leave a comment

Listing categories for a product in Commerce Server 2007 using a SQL query

Commerce Server API is not exactly known for being lightning-fast, so sometimes you want to skip it altogether and just use plain old SQL to get the data. This time I needed to find all categories (at a particular level) … Continue reading

Posted in Work | Tagged , | Leave a comment

List does not exits in Sharepoint 2007 when accessing cache settings

When trying to access the cache settings in Sharepoint 2007 (Site Collection Administration section, Site collection output cache link). The error I got was: List does not exist The page you selected contains a list that does not exist. It … Continue reading

Posted in Work | Tagged | Leave a comment

Dumping / restoring SQL Server data using Powershell

Sometimes you need to transfer data between two SQL Server databases. This Powershell 2.0 script might come in handy. It dumps one or all tables from the specified database to .DAT files and later restores them to another database with … Continue reading

Posted in Work | Tagged | Leave a comment

IIS metabase not persisted at iisreset

iisreset forces shutdown of the IIS services and the information that got added to the metabase (using adsutil, WMI, ADSI etc) can get lost. There are two ways of fixing this: 1. Run C:WINDOWSsystem32IIsCnfg.vbs /save 2. net stop and then … Continue reading

Posted in Work | Leave a comment

Script for extracting SQL Server users, roles and role assignments

A nice little script to generate a script for extracting all users. roles and role memberships in a SQL Server database

Posted in Work | Tagged , , , , | Leave a comment