2008 April | are.ehibou.com

are.ehibou.com

April 21, 2008

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

Filed under: SQL, Side Notes — admin @ 5:06 pm

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

Comments (0)

April 20, 2008

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

Filed under: C#.NET — admin @ 4:54 am

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

Comments (0)