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
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