Error SQL72014.

Applies to: SQL Server 2012 LocalDB.
 

Problem Description.
 

Jamie Thomson shared with me the following error she received when trying to deploy the sample AdventureWorks 2012 project solution on a LocalDB instance:


Creating [AW2008FullTextCatalog]...
Error: SQL72014: .NET SqlClient Data Provider: Msg 9982, level 16, State 100, Line 1 Cannot use full-text search in user instance.
Error: SQL72045: Script execution error.
CREATE FULLTEXT CATALOG [AW2008FullTextCatalog]
       WITH ACCENT_SENSITIVITY = ON
AS DEFAULT
AUTHORIZATION [dbo];

An error occurred while the batch was being executed.
Done building project "AdventureWorks2012.sqlproj"  --  FAILED.






Cause.


This was a test she ran to see what features are supported by LocalDB (SQL Server 2012) and found Full-Text search is not supported.



 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.