SQL 2000 to SQL 2008 R2 Migration Problem - INITCOLVS is not a recognized built-in function name RRS feed

  • Question

  • Hi Guys,

    I have recently migrated a SQL 2000 database from Server-1 to SQL 2008 R2 on Server-2 using Copy Database Wizard. The process happened smoothly. But now I am facing an error while using an application which connects to the migrated database on SQL Server 2008 R2. The error I get is :

    [Microsoft][ODBC SQL Server Driver][SQL Server] 'INITCOLVS' is not a recognized built-in function name.

    I have tried to read up on it and it's something to do with SQL 2000 triggers.

    Can anyone help me sort out this issue.


    Wednesday, March 7, 2012 5:58 AM


All replies