Trigger Status Changes after upgrade


  • Hi,

    I have a query which I've been unable to find the answer to online so far. I was hoping someone can help.

    We are updating our database from SQL Server 2000 to 2104 (via staged upgrade to 2005/2008) and have completed the 1st test upgrade. As part of testing, we're looking in detail at schema and impact on keys/indexes/...

    I ran a query to get info on the triggers in both the 2000 and 2014 database and there are some minor variances.

    Query: select tablename = object_name(parent_obj),* from sysobjects where type = 'tr'

    The variance is on column 'Status' and 'base_schema_ver' which were previously populated with different numbers and are now all 0

    Can anyone explain if this would have any functional impact on the triggers?


    Tuesday, June 12, 2018 2:28 PM


All replies