Friday, 15 January 2016

ER-2: Migration 2009 to 2013: Cannot drop index because it enforces the full-text key for table or indexed view

Following error occurs while converting database and opening 2009 database in 2013 development environment.

The following SQL Server error or errors occurred when accessing the G/L Entry table:

7613,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop index 'Company_$G_L Entry$0' because it enforces the full-text key for table or indexed view 'Company_$G_L Entry'.
3727,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not drop constraint. See previous errors.

SQL:
ALTER TABLE [Database_Live].[dbo].[Company_$G_L Entry] DROP CONSTRAINT [Company_$G_L Entry$0]


Resolution:

The following script need to be executed in SQL on the same database:

DROP FULLTEXT INDEX ON [Database_Live].[dbo].[Company_$G_L Entry]

Thanks
manish


No comments:

Post a Comment