sql server full-text search

sorun:
SQL Server encountered error 0x80070218 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.


çözüm:
EXEC sp_fulltext_service 'restart_all_fdhosts'


sorun devam ediyorsa:
sql server configuration manager --> sql full-text filter daemon launcher
çalıştığından emin ol.


sorun devam ediyorsa:
sql server configuration manager --> sql full-text filter daemon launcher
log on as değerinin sql server'ınki ile aynı olduğundan (local system, local service, network service) emin ol.


tabloya full-text index tanımlama:
tabloya sağ tık --> full-text index --> define full-text index...


full-text index kullanarak arama yapma:
select *
from Mevzuat
where contains (MevzuatAdi, 'YERALTI or DEVLET')


eğer query sonuç döndürmüyorsa:
full-text index'i silip yeniden yarat.

not: query'nin ilk çalışması yavaş olabilir. diğer çalışmalar hızlı olacaktır.

SQL SERVER 2005 - Generate Script with Data from Database – Database Publishing Wizard

http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

the folder contains sqlsubwiz.exe:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2

on the command prompt;
type cd C:\Program Files\Microsoft SQL Server\90\Tools\Publishing
type sqlpubwiz script -d AdventureWorks AdventureWorks.sql

Login failed for user 'sa'. Reason: The account is disabled.

1) Open SQL Server Management Studio and Login
2) In Object Explorer, click Security followed by Logins
3) Right click sa user and select Properties.
4) Uncheck Enforce password policy
5) Select Status. Click the Grant and Enabled radio buttons. Click OK
6) In the Registered Servers top pane, right click on the database and choose restart

sql dönen kayıt sayısını sınırlamak

Declare @RowCount int

IF @RowCount > 0

Set ROWCOUNT @RowCount