You are a database developer for your company’s SQL Server 2000 database. This database contains a table named Products and a table named Companies. You want to insert new product information from a linked server into the Products table. The Products table has a FOREIGN KEY constraint that references the Companies table. An UPDATE trigger is defined on the Products table. You want to load the data as quickly as possible. What should you do?

222.

You are a database developer for your company’s SQL Server 2000 database.
This database contains a table named Products and a table named Companies.
You want to insert new product information from a linked server into the Products table.
The Products table has a FOREIGN KEY constraint that references the Companies table.
An UPDATE trigger is defined on the Products table. You want to load the data as quickly as possible.

What should you do?

Use the ALTER TABLE statement and the ON UPDATE clause to modify the Products table.

Use the ALTER TABLE statement and the DISABLE TRIGGER ALL option to modify the Products table.

Use the ALTER TABLE statement and the DISABLE TRIGGER ALL option to modify the Companies table.

Use the ALTER TABLE statement and the NOCHECK CONSTRAINT option to modify the Companies table.

Use the ALTER TABLE statement and the NOCHECK CONSTRAINT option to modify the Products table.

View Description

No description found.