Turning off SQL 2000 compatibility mode in SQL 2005

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
Posts: 59
Joined: Tue May 13, 2008 7:35 am
Location: Milwaukee, WI

Turning off SQL 2000 compatibility mode in SQL 2005

Post by tjruska » Wed Mar 02, 2011 10:13 am

Our DBA is asking me this question:

"We have an SGVault and sgmaster databases in SQL 2000 compatibility mode on a SQL 2005 instance. We would like to switch the databases to 2005 mode - are there any special considerations to undertake prior to switching?"

They want to ensure this is supported, that's all.

TIA, Tom

Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear

Re: Turning off SQL 2000 compatibility mode in SQL 2005

Post by Beth » Wed Mar 02, 2011 11:24 am

We are unaware of any negative effects to the Vault application that would be caused by changing the compatibility mode of the sgmaster and sgvault databases, but there could be some SQL related item that makes a difference. Did you move the database or upgrade from SQL 2000 to SQL 2005 on the same machine? If you moved the database, did you just detach from the old one and attach to the new one or did you perform a backup from the old one and restore to the new one? If you performed a backup/restore, then SQL Server upgrades the database to a SQL 2005 database.

Some SQL site have good information on dealing with compatibility mode:
http://www.sqlservercentral.com/Forums/ ... 146-1.aspx
Beth Kieler
SourceGear Technical Support

Post Reply