Goldmine 6.x contact sets can be hosted on Microsoft SQL Server 2005.  Before you can create the contact set from within Goldmine you must create the database container in SQL Server 2005.  After the database container has been created in SQL Server 2005 you must set the compatibility level for this new database to 80 or lower.

Execute the following stored procedure:

sp_dbcmptlevel MyNewGoldmineDatabase, 80

Now you can successfully create the contact set (or rehost an existing contact set) into the new database container on MS SQL Server 2005.

If you try to create a new contact set (or rehost an existing contact set) on a database container without first setting the compatibility level to 80 or lower you will get the following error:

General SQL error.
Native SQL error: 1018

Context: create
MSSQL: MyNewGoldmineContactSet: dbo.CONTTLOG

1: Server message: require
2: Server message: Incorrect syntax near 'holdlock'. If this is intended as a part of a table hint, A WITH keyword and parenthesis

BDE Error Cat:Code: [51:3]
BDE: 500 [4/11/1999] GoldMine: 6.60.40525

User: MyUsername
Window:
Template: 8066
Details:
NATIVEMSG: Incorrect syntax near 'holdlock'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now

This has not been tested with Goldmine 7.x.