Hello Everyone, I read on SQL Server Books Online that the Incremental population for Full-Text Indexing: "requires that the indexed table have a column of the timestamp data type. If the table does not have a timestamp column, only full or change tracking populations can be performed....more >>

I have these two tables can link with out problem, it does not work on SQL. 'Store List' table saved successfully 'EQUIPS' table - Unable to create relationship 'FK_EQUIPS_Store List'. ADO error: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_EQUIPS_Store List'....more >>

I am attempting to execute a .bat file that contains the following: ftp -s:c\ftpinput.txt >> c:\ftpoutput ftpinput.txt is a file that contains ftp commands I then receive an error message: The process cannot access the file because it is being used by another process. The file (ftpinput...more >>

Hi everyone, I have a Oracle database application which has an index on varchar2(2000). Now I am moving the database to Sql Server and facing index limitation problem. Sql Server only allow you to build index on column which has less than 900 bytes. Is there anyway in Sql Server to build ...more >>

Hi, I've the FTS in a stored procedure and i am calling the stored procedure from ASP program. Here is the stored procedure : -- ============================================= -- Create procedure basic template -- ============================================= -- creating the store proced...more >>

Hi there, I want to search Japanese characters with Full Text search function. I created a new database on SQL 2000, English Win2k Server. The database's collation is "Japanese-bin" and contains one table that contains 4 fields, which are ID -- int, primary key, identity; PageName -- nvarchar...more >>

"We have a few SQL files on the server that seem to be growing in size and don't know what they are for. The files have similar names of the type: SQL0000700005.hash.gthr" Can someone let me know why and what are these .hash.gthr files are meant for. In my wisdom they are related someways...more >>

Gents, We just made transition to SP3 on our production server. After a lot of hassle rebuilding the FT indexes, we now running a few days with this set-up. However, what we notice is that the FT query performance seems to have slowed down. A process that took 10-12 minutes before, now take...more >>

I am trying to query a table that is on both my test and production machine. It works fine on test. It does not work on production (a cluster). I don't see any error messages in sql or the event viewer. When I run a query on test it returns a result set. Production does not. I see this in th...more >>