This sounds like an interview or homework question. What research have you done?

If I'm wrong about that, what is the exact problem you're trying to solve?

John

That's not two primary keys. It's one primary key constraint over two columns - a composite key.

John

Is this an interview question, by any chance? What research have you done?

John

We can't see what you can see, so help us to help you. Please write a RESTORE statement for each operation. Post all the statements, along with any...

Go on to the Quest website and do a search. There's a utility that you can use to turn a LiteSpeed backup file into a set of native files....

OK, if your're running exactly the same code - and you may want to check it's exactly the same - then it's got to be environmental. Try putting SET...

Sorry, meant SSMS.

John

Mmmm... what happens if you paste that code into SSIS and run it there? I wonder whether it's anything to do with SET QUOTED_IDENTIFIER?

John

I don't understand. If that's how it is in your package, what was it you posted earlier?

You need the single quotes on all lines, even (especially) the ones with...

No. You need to wrap all non-numeric items in your INSERT...

You're muddling up your single and double quotes. Use single quotes (') when quoting something in T-SQL, and double quotes (") when quoting something in an SSIS expression.

John

Please can we see full table DDL? If you don't have a column by which the rows can be ordered, this can't be done.

John

If you use the GUI in Management Studio to delete the login, you can go to the User Mapping tab and untick each database that is ticked. This will...

This could be the answer to your problem, as well. Depending on how your replication is configured, and depending on what testing you need to do, you could either...

Joe

Does your transaction log need to be that big? In other words, does it ever approach 100% full? If it doesn't, it's probably safe for you to shrink...