Thanks guys,

I agree peer to peer seems to be what I was looking for. I'll have a play and see if I can get it working how I need.

BTW Max...

hth,

Out of interest, does it matter if each of the accounts has it's own schema or should they all be reset back to DBO?

What effect do they play?

Coll

Thanks Markus that should save me some time this weekend

Markus, I was just going to post this very question.... so to confirm, if I restore a SQL 7 database onto a SQL 2005 server and change it's compatibility level...

I think the answer you are looking for, is that you need to use a cross join.

Like so:

CREATE TABLE #projects (id int NOT NULL,

description ntext NULL)

go

CREATE TABLE #t (id int...