Full Text Researching

Hi everyone,
I can not use Full Text Researching in my local server. I create a database inwhich I also create a table. And then, when I go to the enterprise manager in order to adjust my table for full text searching, I see that I am not able to do it since the the label for this is unabled for pressing.
So what should I do so as to make this property enabled for my table ?

Thanks

i think you are running sql server on windows xp or windows 2000 professional.

you should be running sql server on windows 2000 server or win 2k3 Server

|||

Yes, I am running my SQL Server on Windows XP but why does this prevent me from this application ?

|||

here's a link to fulltext search whitepaper

http://download.microsoft.com/download/f/b/6/fb62b4bb-6509-41a8-907e-bf0f79f6aa43/Full-TextSearch_Publish.exe

The Microsoft Search service is not available on:

§ Microsoft Windows NT Workstation

§ Microsoft Windows 2000 Professional

§ Microsoft Windows Millennium Edition

§ Microsoft Windows 98

Hardware Considerations

· Multiple CPUs: One to four 500-megahertz (MHz) Xeon III processors.

· Memory: 1 to 4 GB of physical RAM.

·Multiple disk controllers with several channels or a single disk controller with multiple channels.

·Disk I/O sub-systems: RAID 0 (disk striping with no fault-tolerance protection), RAID0+1 and RAID5.

Microsoft Windows 2000 or Microsoft Windows NT 4.0 System Configuration Considerations

SQL Server 2000 is fully supported on both Windows 2000 and Windows NT. However, on Windows 2000, the Microsoft Search service takes advantage of new features that improve full-text index performance. Specifically, the Microsoft Search service has the following enhancements:

· Multi-threaded word breaking.

· Reduced disk footprint.

· Better merge strategy.

· Better query path processing.

Here are some other considerations:

·If you install and plan to use the full-text search feature, then set the Microsoft Windows NT Server or Microsoft Windows 2000 configuration to maximize throughput for network applications. You must not change this setting.

To access this setting on a computer that is running Microsoft Windows NT, follow these steps:

1. Open Control Panel, and then double-click Network.

2. On the Services tab, click the Server service, and then click Properties.

To access this setting on a computer that is running Microsoft Windows 2000, follow these steps:

1. Click Start, point to Settings, and then click Control Panel.

2. Double-click Network and Dial-Up Connections.

3. Right-click Local Area Connection, and then click Properties.

1. Click File and Print Sharing for Microsoft Networks, and then click Properties.

· For a Microsoft Windows 2000 Server, we recommend that you select the Optimize performance for background services option. To access this setting, follow these steps:

1. Open Control Panel, and then double-click System.

2. In the System Properties dialog box, click Advanced.

3. On the Advanced tab, under Performance, click Settings.

4. In the Performance Options dialog box, click Advanced.

· If SQL Server 2000 is installed on Microsoft Windows NT Server 4.0, the Pagefile.sys file must be sized one and a half to two times the amount of available physical RAM. To avoid this consideration, install SQL Server on Microsoft Windows 2000 Server with larger amounts of RAM. This is because the Microsoft Search service in Windows 2000 takes better advantage of the Microsoft Windows NT file system (NTFS file system) cache.

·Place the Pagefile.sys files on their own drives (RAID 0 or RAID 0+1), preferably on a separate controller or least a separate channel off a shared controller.