Sybase ODBC Linked Server from SQL Server 2005 doesn’t like underscores in table names

I hit an interesting issue this week trying to integrate with a Sybase ASE 15.x database via a linked server. I managed to properly formulate my provider strings, and I was able to issue queries against most tables. However, one of my queries failed, giving me the message Msg 7314, Level 16, State 1, Line…


Avoiding Project Corruption in Project Server

Although the symptoms vary, one of the main culprits is a mismatch between the version of Project Pro on users’ machines and Project Server. For example, if you deploy SP2 on the server, you must ensure that you also deploy the corresponding patch to ALL machines with Project Professional that are used to connect to…


Reattaching a Content Database Containing Project Server Project Workspaces

There’s occasions where you’ll find it necessary to reattach a content database containing a PWA site and its associated Project Workspaces. This is essential for Disaster Recovery, migration across farms, or repairing accidental contentDB detachments (or intentional ones – a lot of folks recommend disconnecting most/all contentDBs before applying a WSS/MOSS upgrade. I waive that…