Maybe make sure you have a name for the column like "SomeName =" (with no quotes) prior to the CASE and a comma after END if there is anything else...

Hi Andrew,

I used a version of the following script to resync orphaned users. I made a couple of quick changes to it and came up with this:...

Hi guys, thanks very much for the responses.

We are already running SQL Server 2000 and SQL Server 2008 together on the same box. There is a default...