Tomm Carr (4/29/2008)

Matt Miller (4/29/2008)

The primary characteristic for a primary key (in addition to uniqueness) is immutability, specifically because of its "deisgnated use" in table relations. And that's where...

If it's been running ok for 6 months then I would guess something else has changed.

Has the account that runs the SQL Server/ the SQL Server Agent changed?

Could permissions...

Hi there,

Contrary to many of the posts above, it is possible to update multiple tables from one view.

Check out "instead of" triggers that you place on the view.

These allow you...