Unable to migrate stored procedure from SQL Server 2008 to SQL Azure?

When you moved your tables in Azure the text search feature was disabled. The problem here is that it's not supported yet.

Up vote 0 down vote favorite share g+ share fb share tw.

I am trying to migrate a database from SQL Server 2008 to SQL Azure. I have successfully migrated my tables and views by generating scripts from my SQL Server 2008 instance. However, I am now trying to migrate my stored procedures.

There is one specific procedure that is giving me an error. The error says: Msg 7601, Level 16, State 2, Procedure MyStoredProcedure, Line 10 Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'MyTable' because it is not full-text indexed. For the life of me, I can't figure out how to fix this in SQL Azure.

Can somebody please tell me how to get this resolved? Thank you! Sql-server-2008 sql-azure link|improve this question edited Apr 1 at 16:01marc_s175k14142283 asked Apr 1 at 12:29JavaScript Developer453 70% accept rate.

When you moved your tables in Azure the text search feature was disabled. The problem here is that it's not supported yet. So to fix the problem you must remove the text search reference (ex:CONTAINS or FREETEXT) in your stored procedures.

A probably good alternative is to use Lucene. Net and move the data in Blob storage. Move detail here: implement-search-in-azure-sql I hope this will help you.

Lucene. Net is a much better free text search than SQLServer has anyway. – Craig Apr 4 at 4:14.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.