Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Trigger for truncate

    The presence of a dependent foreign key will prevent truncation of the table. I think I'll use that to my advantage.

    -----------------------------------------------------------------------------

    PRINT 'Creating Tables'

    CREATE TABLE TestTruncate(I INT IDENTITY(1,1), x CHAR(1),...

  • RE: Trigger for truncate

    I'm looking for a structural solution to prohibit truncation. I just tried this method of preventing TRUNCATE TABLE and it did not appear to work (SQL Server 2005). ...

Viewing 2 posts - 1 through 2 (of 2 total)