Thanks so much for all of the replies - I'm very grateful for the ideas/contributions.

I'm going to digest everything and try to come-up with something later this afternoon.

I'll post back...

Thanks for the clarification, Nate.

I feel like I'm stuck with choosing between two bad options, namely:

1) Eschewing referential integrity via Foreign Keys by not defining them (Foreign Keys) on the...

Hi Nate,

Thanks for the reply.

I already have data in my contact tables, so I don't really see how this would help.

Maybe I'm missing your point?

- Simon

Okay, thanks anyway, Daniel.

Thanks very much for the suggestion, Daniel.

Unfortunately, it fails with the following error:

The GroupExpression expression for the tablix ‘Tablix2’ contains an error:

Unable to cast object of type 'System.Object[]' to type...

Paul:

Exactly what I was looking for - expert points of view.

-Simon

Paul:

That's a terrific idea.

It adds a bit of complexity, but it's also a layer of insulation against accidental deletes with cascading effects.

Thanks very much for your input - I'm very...

Thanks for your reply, Paul.

To answer your first question: yes, the entities are as you described. One WebAccountID...

I know when I started my SQL Server learning in earnest (for SQL Server 2005), the best three things that I used were:

1) A developer license for SQL Server (available...

I'd image there will be a lot of Vic jokes this week, but that was a good one...

(My beagle is cowering at home...)

Thanks very much, Andrew. Your help is much appreciated!

Hi, Andrew. Did you ever figure this one out?

Ray, yes, that is correct. From my experience the rankings are fairly solid, in other words you shouldn't get too many surprises.

Fine by me. I'll do my best to make it, but if I can't I'll make sure my auto-pick is set.

Just as a point of reference, you can use the DBCC CHECKIDENT command to inquire into identity values on a column.

You can also use it to reseed the value of...