none
SQL70010: A FROM clause is not supported for CREATE FULLTEXT STOPLIST statement RRS feed

  • Question

  • Is there a work-around for not being able to create stop lists in SSDT?

    CREATE FULLTEXT STOPLIST [MyStopList] FROM SYSTEM STOPLIST;
    

    SQL70010: A FROM clause is not supported for CREATE FULLTEXT STOPLIST statement

    Wednesday, August 13, 2014 8:21 PM

Answers

  • There is no support for the FROM clause.  Because the from clause references a stop list definition that is not in the project, SSDT has no way of understanding the stoplist without the referenced database. This is one example where the declarative model limits some of the supported TSQL syntax as if the elements in the database are not completely defined in the project or referenced projects, SSDT cannot model them correctly in the project system.
    Thursday, September 4, 2014 6:33 AM