Sql full text index not populating

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Sql full text index not populating

Author

Topic

aminnagpure
Starting Member

3 Posts

Posted - 2010-05-28 : 10:30:18

i configured full text index on a varchar column, but its not getting populated

iam using sp2 windows 2003 server, with sql server 2008 web edition

iam getting the error pasting below

A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is cvsearch (id: 13); catalog name is cvs (id: 7); table name candidatesRegistration (id: 1138103095). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

Man Behind Firewall

aminnagpure
Starting Member

3 Posts

Posted - 2010-05-28 : 12:57:53

i found the solution for it, and iam posting it so it wud be useful for others

go into sql server configuration manager

just run the sql full text filter data dameon and the mss sql server in the same login
i.e local system

by default ful text runs on local service, change it local system it works

Man Behind Firewall

sabra
Starting Member

25 Posts

Posted - 2010-05-30 : 06:21:35

Need help!
What's error in this code?
CREATE TABLE BLOBTest
(
BLOBID int IDENTITY NOT NULL,
BLOBData varbinary(max) NOT NULL
)
GO
INSERT INTO BLOBTest(BLOBData)
SELECT * FROM OPENROWSET(BULK N'D:\DSN0022.jpg', SINGLE_BLOB);

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources