Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server)) You might have seen the above error very ...

It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance. I've ensured to install relevant FULLTEXT component but surprisingly unable to see this ...

I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to ''Find Fast'' that ships with Microsoft Office. There is a downside in using this option on a Windows ...