Thanks for the answer, but I think you missed my point.

I'm not asking about licensing, I'm asking about configruing a server with 2 socekts / quad core (IE SQL sees...

Exactly!  Something like this:

Jo, thanks for your reply,

1. Structure (sorry about that - that's what happens when you hurry and don't have a great tool - I just downloaded ApexSQL Script...

Thanks for responding.

Great point!  However, wouldn't (01,02,03,10,12,20) sort as (01,02,03,10,12,20)? Would this concept mess it up if I had data such as (33256-0456, 33256)!!!?

Here's what I did:

1.  I dropped the indexes, removed...

Hope it's ok that I add my question to your thread.

I created a clustered index on column Zipcode, intending that the columns would always be sorted. Then I created a...

You would purchase Per CPU licensing. It would cost more, but you can have unlimited users.

Our applications are non web and don't have that many users. I...

Jonathan,

Something I almost missed. You said: "(no mixing)"...

Does that mean if we have user CALS we can't use device CALs?

Hopefully that's not the case!!!

Marc

Jonathan, Thanks for the reply.

Honestly, that's what I assumed (big software corporate mucky-muck). Sadly I was hoping for the best!!!

I wish we could afford the per CPU...

Thanks.

I've read about User or Device CALS, but am still not 100% clear on if they are reserved/assigened to specific users or to a specifics device.

Maybe the best way...

To the best of my abilities there are no permission problems.

Here are a few more details:

The tables / queries used (WeaponsDB.mdb to WeaponsDB SQL database)

Select * From tbl_WeaponType

Select *...

I hate to say this, but I'm not sure what I need to do. I have run a trace on both boxes to see if I can see differences,...