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

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.

Thanks

Answer 1

Please try the solution in this thread

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/66a6e3db-3ec6-4214-9d2f-a6a532a37db5

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 2

Thanks for that.