Wayne,

It looks like this is what I need. However, I keep getting an error because the the phone field is not int.

SELECT contact_KEY,

...

Hope this helps in explaining what I need:

Ideal Result

client_id namecontact_KEYsalutationmailing__contact_address_type_KEYaddress_1cityaddress_2state_abbreviationpostal_codecontact_address_type_KEY Business Fax Home Mobile

CREATE TABLE [dbo].[Contact_Phone](

[contact_phone_KEY] [int] IDENTITY(1,1) NOT NULL,

[update__staff_KEY] [int] NOT NULL,

[update_date] [datetime] NOT NULL,

[contact_KEY] [int] NOT...

I found the answer. I temporarily disabled the trigger on that table:

--ALTER TABLE [membership] DISABLE TRIGGER ALL

-- do work here

--ALTER TABLE [membership] ENABLE TRIGGER ALL

Thank you everyone for...

I did not create this database. There may be a trigger on this table.

Is there a way to temporarily disable the trigger while I do the update?

Thank you.

Thank you.

I have an SSIS package that copies data from one database to another.

I want to give some users an option to run this from a asp.net web page. I...

rjv_rnjn + Bru

Thank you! The SSIS package did the trick.

We have a web database and a local database.

There is no input in the web database. Only data is served on the website.

All input is done on the local...

I found a solution here:

http://www.mssqltips.com/tip.asp?tip=1555

How would I run it against all tables without specifying each one?

Sorry. Nevermind. I misspelled a field name.

Thank you everyone for the suggestions.

For now, we completely restored the db. We are currently reviewing the cause.

Thank you very much! This is very helpful!

Ramesh and Christopher Stobbs:

Thank you very much. This is exactly the solution I was looking for!

Norbert

SSChasing Mays,

Perfect! Thank you very much for your help.

Norbert