Jo, you're an absolute gent (unless of course you're a lady)

Thanks...

Jo Pattyn (12/4/2008)

---

About the non-clustered index on device.simid.

By default, when you create a foreign key, sql server doesn't automatically add an index on both columns involved in the master-parent relationship...

Jo, Thank you so much! That is exactly what I was wanting to acheive. Thank you so very much!

I've switched the real table and field names into the script...