i having Mssql Server 2000. My System OS is Windows xp and Ram 1 Gb
I having Install MS Sql Sever Service Pack 3 in my system. then i
install Full Text Search component
I run this Command
SELECT @.@.VERSION
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack
2)
SELECT SERVERPROPERTY('productversion') return =8.00.760
SELECT SERVERPROPERTY('productlevel')= Return SP3
SELECT SERVERPROPERTY('IsFullTextInstalled') returns: 0
but i run This command i got This Error
EXEC sp_fulltext_database 'enable' returns:
Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot
be loaded.
i check the Microsoft Search service in Computer Management,
Microsoft Search servic runing Properly
pls advice me
Try this :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 This is the page to reinstall Microsoft Search (Full-Text) Service.
Good luck.
没有评论:
发表评论