• Thanks Perry. I ran the upgrade advisor and have these issues. Do you have any idea how to go about fixing this, I spent a whole lot of time researching on a resolution but had no luck.-

    Method not found: 'System.Collections.Generic.IEnumerable`1<Microsoft.SqlServer.Management.SqlParser.Parser.Error> Microsoft.SqlServer.Management.SqlParser.SqlCodeDom.SqlCodeObject.get_Errors()'.

    for a couple of different objects - OLDSYSTEMTABLES, SPHELPTRIGGERNEWCOL,OUTPUTINTOFULLTEXT, ORDERB ORDINALS, DROPSYSOBJ, NONANSIOUTER, MERGE,OUTPUTTARGETHASTRIGGER,SYSLOCKINFO,

    ...

    Also got Full-Text Search has changed in SQL Server 2008

    The advisor says these have to be fixed prior to upgrade.