Microsoft SQL server 2005:SQL Script to check if an object contains fulltext index specified

Microsoft SQL server 2005:SQL Script to check if an object contains fulltext index specified

IF EXISTS( SELECT * FROM sys.objects o INNER JOIN sys.fulltext_indexes fti ON o.object_id=fti.object_id WHERE o.name=’Your table or view name’ ) BEGIN –Your Code Here END

April 21st, 2008 | Category: Side Notes, SQL | Leave a comment

Data Dude and Visual Studio 2005: Full Text Indexes on Views With Schema Binding are Ignored During Deployment

Data Dude and Visual Studio 2005: Full Text Indexes on Views With Schema Binding are Ignored During Deployment. SQL Script import works. *.fulltextindex.sql files are created, but indexes are ignored to deploy …  This  is  solved in visual studio 2008.  In case you are using  2005  put these scripts to your post deployment scripts ….

April 20th, 2008 | Category: C#.NET | Leave a comment