First, it is possible to modify an existing column to make it an Identity. That might solve your problem easily.

Second, to help you with the trigger, we would need...

You might want to take a look at ApexSQL Diff (www.apexsql.com), or the RedGate Compare and Data Compare products.

I use Apex's product for migrating structure, code and data between QA...

To drop those indexes, you first need to drop the PK constraint. In Management Studio, you will find those under Keys, under the table. Of course, you'll probably...

You can have the trigger test for updated rows where the ID (or other PK) is the same, but other columns (even just one) are not the same. That...

I always recommend doing pivot operations in a front-end application, like Excel or Reporting Services, instead of in SQL. They do it better, more easily, and faster.

Is this something you will be doing once, or doing repeatedly?

If once, the Import/Export wizard will be fine. If repeatedly, then you'll need to either save the import package...

MrBaseball34 (7/24/2008)

---

Would this work correctly?

AND (((@PaymentDtTmStart IS NULL)

AND (@PaymentDtTmEnd IS NULL))

...

You'll have to add the primary key to a Where clause in the trigger.

(Your sample data doesn't seem to match your requirements. Take a look at the dates where the value is 6, they go 15, 17, 20, but you have a...

Hey, the Romans started it! It's all their fault, with their "SPQR"...

Thanks. Was pretty sure I wasn't missing it.

I'm looking at the BOL data on DDL triggers, and I don't see Truncate Table as one of the actions. Am I overlooking it?

Steve Jones - Editor (7/23/2008)

---

If you have serious auditing requirements, deleted records aren't allowed. You "mark" them as logically deleted (some flag), but you keep them around.

Worse case, you set...

Wouldn't know about a bug in the driver. I use temp tables for that kind of thing. It's not like I'm expecting SQL Server to manage transactions in...

I have SQL Server Agent send e-mails based on whether the job succeeded or failed. I have them go into different folders in Outlook based on the server and...