I wouldn't think so....you should create an application role and use that for access, you certainly should not be handing out SA passwords if you want to retain any type...

Look at the screen once you have added the file don't just go blindly clicking buttons, *before* you look at the screen.

can you see the attach db dialog?

once you add the mdf, there is a combobox for owner listing server user, drop it down and select sa.

Change the owner to be sa in the attach DB dialog

If you business logic dictates that this combination of columns allows for duplicates, then it is by definition not a primary key, it may be worth examining your table to...

IMHO what you want is a consistent peice of code that will handle both situations, i.e. the file requires preprocessing.

If the qualifier is ^ then leave it alone and process...

Try Select @@Servername

That *should* give you the server name, SELECT serverproperty('InstanceName') gives me null on a couple of machines.