| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Accent problem Posted by Depaula at 10/14/2004 7:23:08 AM I'm having a problem with character accentuation in SQL Server 2000.
The database was created with SQL_Latin1_General_CP850_CI_AI Collation and
table varchar fields are using the same collation.
The problem happens when I use characters with accentuation, database is not
saving the correct ...more >>
number of rows in catalog Posted by James Brett at 10/13/2004 10:33:54 AM Hi
Is there a system query that will tell me the number of rows in a given
catalog?
Cheers
James
...more >>
FTS ON View in Yukon ? Posted by cwertman NO[at]SPAM webchamps.com at 10/13/2004 8:15:58 AM I am eargerly awaiting my MSDN Universal, until then I am very
interested to know if Yukon will allow a View to be FT Indexed ? I am
working on a scenario right as we speak that may be worth pushing off
for the moment if SQL 2005 Will support these
Anyone ?
Or do I just need to jump through...more >>
Limitations, etc. Posted by Greg D. Moore (Strider) at 10/13/2004 3:39:53 AM
We're looking at rewriting part of one of our applications and FINALLY
moving from SQL 7.0 to SQL 2000.
One reason we haven't is currently the table we index has 3 columns we want
to be able to do a FT search against and since SP3 on SQL 7, MS has
"changed" the rules.
So, our current solu...more >>
Question about catalog schedule Posted by Tom at 10/13/2004 12:37:03 AM When I start a full population on a full_text catalog manually (Right click
on a full_text catalog and click start full_text population), it works
perfectly. But when I try to schedule a full pupulation on the same catalog,
it seems like it never start to do the full population. Do I need to...more >>
CONTAINSTABLE VS FREETEXTTABLE in Windows SharePoint Services Document Search Posted by Kevin Lewis at 10/12/2004 5:37:46 PM The Windows SharePoint Services (WSS) API has a method SearchDocuments in
the SPWeb class. This method accepts a search string and eventually
executes a SQL Server stored procedure that calls the FREETEXTTABLE function
to do the full text search. It seems to me that CONTAINSTABLE is a more
rob...more >>
Indexing Service and Full Text Search? Posted by Jack at 10/12/2004 5:22:18 PM I have a solutions database I am adding Full Text Search to.
Unfortunately, a huge part of the "solutions" resides on a shared lan in the
form of attachments.
I've used FTS before, and I've used Index server before (though never on
files located remotely)
Are there any resources on using bo...more >>
CONTAINS search not working on live server Posted by James Brett at 10/12/2004 4:45:14 PM Hi
I'm dealing with a company that have 3 web servers a test, staging and live.
All these servers are sql server 2000 and are situated offsite. I do not
have dirrect access to them, I have to send them email with scripts when
things need changing.
The website works on the test and the stagi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
columns in full text query Posted by James Brett at 10/12/2004 3:48:18 PM Hi
Is there a system query that tells me which columns are a fulltext index for
a particular catalog?
Cheers
James
...more >>
Combining full text search results with index server/service Posted by jack at 10/12/2004 3:19:03 PM I have a solutions database that I'm setting up Full text search on. Part of
the "solutions" is a huge folder of attachments on the lan.
I've done both FTS alone and also Index server alone.
Are there any whitepapers or good websites that talk about combining the
two? I'd like to conduct ...more >>
Full text searching on a bulletin board system Posted by Shabam at 10/12/2004 3:06:02 AM I was told by a programmer that the full text searching on ms sql is only a
good solution on static data, meaning no new data is being added frequently,
as the indexes have to be rebuilt each time someone is added/removed.
I will be running a bulletin board system, so there will be many new pos...more >>
Does FTS in SQL 7 have known issues with not indexing records? Posted by Daniel Crichton at 10/11/2004 1:58:29 PM I've been testing using a full text index on a few columns in one of my
databases, and I'm having trouble with the index appearing to miss records.
I have stopped all updates on my database, and done a full population of the
SearchTitle field in my STK table. I have then waited until the full tex...more >>
Yukon Stability Posted by robnews NO[at]SPAM iGive.com at 10/11/2004 9:14:30 AM We're about to deploy a new application, based primarily on FTS.
Because it is an isolated use, I'd like to take advantage of the FTS
features in Yukon. Is Yukon stable enough to go into a limited
production environment? I understand that there is at least one more
beta release to go.
We'd...more >>
Index fails to build on Cluster Posted by Greg D. Moore (Strider) at 10/9/2004 5:50:02 PM
We just moved a system to a new cluster and we can't build a full-text index
on a table.
The crawl seed <MSSQL75://SQLServer/2116e6df> in project <SQLServer
SQL0001200005> cannot be accessed. Error: 8007007f - The specified procedure
could not be found. .
Search KB articles indicates that...more >>
full-text index table greyed out Posted by smandelecha NO[at]SPAM gmail.com at 10/9/2004 9:18:43 AM Hi,
I am connecting to SQL Server 2000 on a Windows NT machine, remotely
via a client on a Windows XP Pro machine. Although Full text search
service is running on the server, I cannot access it on my client
machine. It appears greyed out on the windows XP machine.
Besides, I have scheduled it f...more >>
Newbie Question on searching text Posted by Shabam at 10/9/2004 6:16:34 AM I have a bulletin board application (written by a programmer) and want to
allow users to search the database for keywords/phrases. Doing a basic
search eats up the cpu like crazy, and I know there are some strategies on
how to get this done right.
Can someone provide me with an overview of ho...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |