Can't drop text index using ASE 11.9.2 and full text search add in

Hello,

We are having a problem dropping a full text retrieval index from our
database.  When we issue the command sp_drop_text_index indexName, we
get the following error:

Index 'indexName' is not a Text Index
(1 row affected)
(return status = 0)

And yet if I do an sp_help_text_index, the index is there and I can see
information on it.

Has anyone else run into this problem?  Any help is greatly appreciated.

Thanks

Jon

0
Jonathan
6/5/2000 6:51:11 PM
sybase.sqlserver.general 4269 articles. 0 followers. Follow

1 Replies
777 Views

Similar Articles

[PageSpeed] 32

Jonathan,

In sp_drop_text_index the text index name must be fully qualified in the
format "table_name.index_name" as shown in Appendix A of the FTS User's
Guide.

Gordon

Jonathan Cates wrote:

> Hello,
>
> We are having a problem dropping a full text retrieval index from our
> database.  When we issue the command sp_drop_text_index indexName, we
> get the following error:
>
> Index 'indexName' is not a Text Index
> (1 row affected)
> (return status = 0)
>
> And yet if I do an sp_help_text_index, the index is there and I can see
> information on it.
>
> Has anyone else run into this problem?  Any help is greatly appreciated.
>
> Thanks
>
> Jon

0
Gordon
6/12/2000 4:45:51 PM
Reply:

Similar Artilces:

Does ASE 11.9.2 include full text search?
Sybooks 11.9.2 (and 11.5, for that matter) say that the full text search product is part of the ASE distribution. The install instructions say to use the full text search product media, but I do not see that. Suggestions? -- Frank Burleigh Indiana University School of Law 211 S Indiana Ave Room 254 Bloomington IN 47405 812-855-9170; (fax) 812-855-0555 burleigh@indiana.edu ...

Can't edit text in the 'Basic text Box' OR 'Rich Text Editor'
have, DNN 3.0.13 installed on Windows server 2003have tried sitting at the server and on a workstationI first tried to edit the text on the home page, the text editor shows up but it is empty/blank, I couldn't put my cursor in the text area and type anything.I have also tried to create a new page and try to edit a text area, same problem.....I have also tried to use the events module and tried to add an event, same problem...PS. preview in not on.Thanks in advance, Peter What browser are you using?Are you using a custom skin?Icthus TechnologiesBuilding Faith on the Internet Im havi...

Support for Full Text Search in ASE Linux 11.9.2?
Are Standard and/or Enhanced Full Text Search supported in ASE Linux 11.9.2? Regards Bart van Kuijk This is a multi-part message in MIME format. --------------29E9C75A7943D0A7E18D475B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sybase UK Ltd wrote: > Are Standard and/or Enhanced Full Text Search supported in ASE Linux > 11.9.2? > Regards > Bart van Kuijk Hi Bart, No, it is not available for Linux. Full Text Search engine is provided by Vignette and they have not ported to Linux as far as I know. You may want to request it....

Where is "full text search" in ASE NT 11.9.2?
Sybooks suggests that there are two available full text search options for ASE: "standard" and "enhanced." The text says that standard is in the ASE NT package. Where is it? -- Frank Burleigh Indiana University School of Law 211 S Indiana Ave Room 254 Bloomington IN 47405 812-855-9170; (fax) 812-855-0555 burleigh@indiana.edu Good Question! The standard flavour is available on a separate CD (Part # 13955-55-1150-41). The Enhanced version still needs to be ordered separately (I am led to believe) which we have done. I am still waiting for it to arr...

How can you use SQL Full Text Search CONTAINS() with an asp.net 2.0 ObjectDataSource using @Parameters?
How can you use SQL Full Text Search CONTAINS() with an asp.net 2.0 ObjectDataSource using @Parameters? MSDN says something like this, but only works directly using like the Query from SQL Manager: USE TestingDB;GODECLARE @SearchWord NVARCHAR(30)SET @SearchWord = N'performance'SELECT TestTextFROM TestingTableWHERE CONTAINS(TestText, @SearchWord); I tryed to mak something like that work with the DataSet DataAdapter Query Builder for the ObjectDataSource, but you can't use DECLARE or SET. SELECT TestTextFROM TestingTableWHERE CONTAINS(TestText, @SearchWord); But again it say...

Searching database text w/o using full-text indexing
I am using the following plumbing code to search a database column for a keyword. I can't use full-test indexing so I came up w/ this work around. But It has many flaws so I'm looking for a better way. Thx in advance. 'Open sql connection SqlConnection1.Open() Dim datareader2 As SqlClient.SqlDataReader datareader2 = cmdFindRowsWithKeyword.ExecuteReader Dim strMsg As String Dim intRowToFlag As Integer Dim strRowsToGet As String Dim strKeywordAsTyped As String Dim strKeywo...

Can't Connect to ASE 11.9.2
When the program try to connect to ASE using connect, the SQLCODE return is -1 and SQLDBCODE is 999 and SQLERRTEXT is empty. When the program retry, it OK. Why ? Any suggestion is welcome. PB version is 5.0.04 Regards, Michael Resolving 'Unable to load the requested Database interface' and 'DBMS is not supported in your current installation' This error can appear in the PowerBuilder/Infomaker development environment whenever an attempt is made to connect to a database, and one or more of the dynamic link libraries (DLLs) required to make that connection...

can't find my view to full text index!!
 i can't full text index my view... it saids that i must define a unique column for my view ..but how do you define a column to be unique for views?  could you please describe your question more clear? I'm afraid i cannot follow you quite well. Anyway, take a look at the following links and see if they can help: http://support.microsoft.com/kb/928537 http://www.microsoft.com/technet/prodtechnol/exchange/2000/library/BPDFTI.mspx http://www.microtype.com/resources/articles/ftr.html Hope my suggestion helps This response contains a reference to a third party World Wide...

superreview requested: [Bug 315633] "Create Profile" dialog text doesn't match button text: "Click Finish"->"Done", "click Next"->"Continue" : [Attachment 206616] Use Mac-appropriate text in profile #2
Steuard Jensen <steuard+mozilla@slimy.com> has asked Daniel Veditz <dveditz@cruzio.com> for superreview: Bug 315633: "Create Profile" dialog text doesn't match button text: "Click Finish"->"Done", "click Next"->"Continue" https://bugzilla.mozilla.org/show_bug.cgi?id=315633 Attachment 206616: Use Mac-appropriate text in profile creation https://bugzilla.mozilla.org/attachment.cgi?id=206616&action=edit ...

can't bind text to a text box with text mode password
Hi all, I am using Visual studio 2003.What i am doing a user can edit his account for that reason i have web form with multiple text boxes. I take user information from the data base and bind that to related text boxes....like txtName , txtPhone but text mode for password text box is password. and when i bind data to password text box it remains empty while other boxes with text mode single line show data. dim txtPassword as textbox txtpassword.textmode=password txtpassword.text=reader.getvalue(5) y i don't see ne thing in text box while same code works ok when text mode is single lind ...

Why i can't connect to ASE 11.9.2 for linux
Platform: RedHat Linux 7.2 server is stared. ------------------ #netstat -a Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 *:cvspserver *:* LISTEN tcp 0 0 entserver:4100 *:* LISTEN ../showserver USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 761 0.0 3.9 30856 12704 ? S 13:32 0:00 /db/sybase11/bin/dataserver -sentserver -d/db/sybase11/master.dat ...

Can't find full-text search engine (SDS) !!
hi, I am running ASE 11.9.2.9 on NT 4.0. I can't find the full-text search engine (SDS), as mentioned in ALL documentations of Sybase. I need it ,can Anybody help me? I will need perhaps the enhanced version of this search engine (by Verity software), does anybody know where I can try or buy it ? Thanks. > I am running ASE 11.9.2.9 on NT 4.0. > I can't find the full-text search engine (SDS), as mentioned in ALL > documentations of Sybase. I need it ,can Anybody help me? > > I will need perhaps the enhanced version of this search engine (by Verity ...

can't enter text in text fields on new version (1.5.0.2)
Name: dean chamberlain Email: hybridd_at_aol.com Product: Firefox Summary: can't enter text in text fields on new version (1.5.0.2) Comments: just downloaded the new version yesterday. i now have intermittent problems entering text in the address bar, search and other text fields. the browser is useless and i've been forced to use IE. I'm on a Mac OSX 10.3.9 Browser Details: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2 ...

Can't start X server and can't install NVIDIA display driver when upgrade to 11.3 from 11.2
Hi, all, I upgrade to 11.3 from 11.2 according to official portal "system upgrade". Code: -------------------- #zypper ref -------------------- Code: -------------------- #zypper dup -------------------- After complete, I restart the system, it just can login in by terminate. When I run Code: -------------------- #startx -------------------- Got below message: > > ... > Current version of pixman: 0.18.0 > Before reportign problems, check help http://wiki.x.og > to make sure that you have the latest version. > Ma...

Web resources about - Can't drop text index using ASE 11.9.2 and full text search add in - sybase.sqlserver.general

Resources last updated: 12/8/2015 3:48:07 PM