Hey G Bryant McClellan thanks for the pointers.

You say in reference to Clustered PK's 'By default the Primary Key will be but is that the one you want? Clustering orders...

Apologies for the apparent cross-post it wasn't intentional. I asked the question here first and then after getting some idea of where my problem lay I posted in the...

Thanks Ian I'll try doing the index.

I didn't rewrite the query I rewrote the ASP.

Originally I was getting all the mainMenuItems which is around 10 and then looping...

I've managed to sort it thanks. It turns out I needed to add the SERVER\IUSR_SERVER account to the Administrator group in the Computer Management snap-in.

Why would this be and...

Continuation of above post........... Sorry, I hit return by mistake. Any advice, links, general information you can offer on this subject is very much appreciated. Thanks in...