I haven't read all the detail becuase I've been doing this for a while, but the starting point would be in BOL

ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMMain3/html/288a1701-d3d1-4410-9f3a-9fae0d5638f4.htm

This is as it relates to SQL Mobile, but...

The biggest problem with American football is that it takes 3 hours to play a 60 minute game. It's just a little bit of overkill really. I mean, from my...

Pams commments are very valid.

They also point to the fact that if you maintain the referntial integrity in the database, some developer who comes along cannot destroy your data becuae...

There are a lot of sports in the world, but there are really only 6 or 7 huge sports in the world: football, baseball, basketball, hockey, soccer, tennis, NASCAR/racing.

That...

Sounds to me like you might need to control that particular scenario programmatically.

From my understanding, you usually define uniqueness via an index but I don't believe they are conditional.

As for...

The relationships themselves do not speed up queries.

Primary and foreign keys provide great starting points for indexes which do speed up queries (if you build them correctly).

These relationships are...

And to add one final point, this is apparently a known issue in SQL 2005 RTM and is fixed in SP1.

Hope this helps someone else.

Brilliant!

And can anyone tell me if they have actually come across a usable menu on phone. Can't say I've seen too many that worked for me.

Some you can get to...

So, to answer my own question for any who are thinking of trying this.

My real problem was in creating a certificate that was trusted becuase that was what it wanted....

Didn't have to do anything special for this.

Just make sure that the user has access on both machines. In fact, at the client site it just worked.

Perhaps it is not the Linked Server that is the problem.

The error indicates that there is a problem at the publisher.

Perhaps what you need to look at is something to...

Thats a might ig step going from Transactionl replication to Snapshot replication.

I take it your subscribers don't send data back to the publisher.

From a different perspective, table names with spaces...

If you are not interested in the actual value other than as a link to other records, I can highly recommend that you use UNIQUEIDENTIFIER as your datatype.

Failing that, you...

When you use replication, you logon to SQL Server as a specific user. This is most likely a different user to the one you use when you connect to Query...

Is there a specific reason have a select inside your inner join?

Not that it is wrong to do so, but may be confusing to the next person who needs to...