Could you post the SP?

Hi

Thanks for your replies. I just wanted to know because this particular table will have 60 million rows when mature. There are no updates, just insert and deletes.

...

Thanks, I appreciate it. I know it was a simple question, but if you never do it, you just don't know!!

Hi thanks for the replies.

So adding a non clustered PK will not be detrimental to queries or updates? I wuld be in favour of this, together with the partition...

Hi again,

Thanks for taking the trouble to reply. I have decided to accept the position, after weighing things up.

However, I was a little alarmed when, reading another thread elsewhere...

Ok,

As I said, I am using the wizard, so here is the VB generted code (sorry there is so much). Perhaps it is an Access permission thing? I...