|
|
You're in the
sql server full text search
group:Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_table,
sql server full text search:
Hello:
running SQL2000 SP3 (8.00.818) first 1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we noticed several system stored procedures were missing, including, master..sp_fulltext_table --I found a copy on our test machine and transfered it to production server where it is now seen as dbo owner but not a system table rather a user table.... 2) when running... EXEC sp_fulltext_table 'DOC', 'create', 'DOC', 'indx_intDOCunid'I get Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_table, Line 122 Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options. ... which is: -- ADD TO CATALOG DBCC CALLFULLTEXT ( 5, @ftcatid, @objid ) -- FTAddURL( @ftcatid, db_id(), @objid ) QUESTION: how do I get out of this mess. Thanks
Terry,
How did you "rebuild" SQL on the new machine? Did you install it from the SQL Server CD or install it as a disk image? You should NEVER be missing "several" or any system stored proc's, some that call internal system extended system procs that are in fact dll's and need to be registered on your new machine. DBCC CALLFULLTEXT is one such internal system stored proc and if this is not working correctly, then all of your Full-text Search (FTS) functionality is suspect. As how to get out if this mess... That would depend upon the level of missing stored procs, if it is just MSSearch / FTS, you can use the procedures in the following KB article to manually re-install FTS / MSSearch: 827449 How to manually reinstall the Microsoft Search service for an instance of SQL 2000 http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 Hope that helps! John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] "Support" <Support@discussions.microsoft.com> wrote in message news:255D5646-23E9-4DA0-B11E-BC1AE0AE091C@microsoft.com... > Hello: > running SQL2000 SP3 (8.00.818) > first > 1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we > noticed several system stored procedures were missing, including, > master..sp_fulltext_table > --I found a copy on our test machine and transfered it to production > server > where it is now seen as dbo owner but not a system table rather a user > table.... > 2) when running... > > EXEC sp_fulltext_table 'DOC', 'create', 'DOC', 'indx_intDOCunid'I get > Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_table, Line 122 > Incorrect DBCC statement. Check the documentation for the correct DBCC > syntax and options. > > .. which is: > -- ADD TO CATALOG > DBCC CALLFULLTEXT ( 5, @ftcatid, @objid ) -- FTAddURL( @ftcatid, db_id(), > @objid ) > > QUESTION: how do I get out of this mess. > Thanks > Terry
John:
Thanks we installed SQL from scratch and applied all the service packs and then ran the "Copy Database Wizard" So far, we have missed: master..sp_addrole master..sp_fullText_Table master..sp_grantdbaccess I will read the article. Thanks [quoted text, click to view] "John Kane" wrote:
> Terry, > How did you "rebuild" SQL on the new machine? Did you install it from the > SQL Server CD or install it as a disk image? > You should NEVER be missing "several" or any system stored proc's, some that > call internal system extended system procs that are in fact dll's and need > to be registered on your new machine. DBCC CALLFULLTEXT is one such internal > system stored proc and if this is not working correctly, then all of your > Full-text Search (FTS) functionality is suspect. > > As how to get out if this mess... That would depend upon the level of > missing stored procs, if it is just MSSearch / FTS, you can use the > procedures in the following KB article to manually re-install FTS / > MSSearch: > > > 827449 How to manually reinstall the Microsoft Search service for an > instance of SQL 2000 > http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 > > Hope that helps! > John > -- > SQL Full Text Search Blog > http://spaces.msn.com/members/jtkane/ > > > > "Support" <Support@discussions.microsoft.com> wrote in message > news:255D5646-23E9-4DA0-B11E-BC1AE0AE091C@microsoft.com... > > Hello: > > running SQL2000 SP3 (8.00.818) > > first > > 1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we > > noticed several system stored procedures were missing, including, > > master..sp_fulltext_table > > --I found a copy on our test machine and transfered it to production > > server > > where it is now seen as dbo owner but not a system table rather a user > > table.... > > 2) when running... > > > > EXEC sp_fulltext_table 'DOC', 'create', 'DOC', 'indx_intDOCunid'I get > > Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_table, Line 122 > > Incorrect DBCC statement. Check the documentation for the correct DBCC > > syntax and options. > > > > .. which is: > > -- ADD TO CATALOG > > DBCC CALLFULLTEXT ( 5, @ftcatid, @objid ) -- FTAddURL( @ftcatid, db_id(), > > @objid ) > > > > QUESTION: how do I get out of this mess. > > Thanks > > Terry > >
There have been cases where for some reason the service pack is incompletely
applied, but the upgrade process appears to complete successfully. I would advise you to reapply the SP and watch to see if this proc is now marked as a system object. This should indicate successful application. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Support" <Support@discussions.microsoft.com> wrote in message news:255D5646-23E9-4DA0-B11E-BC1AE0AE091C@microsoft.com... > Hello: > running SQL2000 SP3 (8.00.818) > first > 1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we > noticed several system stored procedures were missing, including, > master..sp_fulltext_table > --I found a copy on our test machine and transfered it to production server > where it is now seen as dbo owner but not a system table rather a user > table.... > 2) when running... > > EXEC sp_fulltext_table 'DOC', 'create', 'DOC', 'indx_intDOCunid'I get > Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_table, Line 122 > Incorrect DBCC statement. Check the documentation for the correct DBCC > syntax and options. > > .. which is: > -- ADD TO CATALOG > DBCC CALLFULLTEXT ( 5, @ftcatid, @objid ) -- FTAddURL( @ftcatid, db_id(), > @objid ) > > QUESTION: how do I get out of this mess. > Thanks > Terry
You're welcome, Terry,
What you may be able to do is to use "ProcSyst.SQL" (in the \MSSQL\Install\ folder) and search for each of the below system stored procs and copy out the code that creates these systems stored procs and create them individually. A service pack does not re-install these system stored procs, at best they may update them, but unless there is a fix for these procs, most SP's don't re-create them. If this fails resolve this problem, you may have to remove & re-install SQL Server and be sure to be logged on as Admin or as a member of the machine's Administrators group. Hope that helps! John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] "Support" <Support@discussions.microsoft.com> wrote in message news:D23C3C49-C0FD-4225-AB75-D14D61A7A8E7@microsoft.com... > John: > Thanks > we installed SQL from scratch and applied all the service packs and then > ran > the "Copy Database Wizard" > So far, we have missed: > > master..sp_addrole > master..sp_fullText_Table > master..sp_grantdbaccess > > I will read the article. > Thanks > "John Kane" wrote: > >> Terry, >> How did you "rebuild" SQL on the new machine? Did you install it from the >> SQL Server CD or install it as a disk image? >> You should NEVER be missing "several" or any system stored proc's, some >> that >> call internal system extended system procs that are in fact dll's and >> need >> to be registered on your new machine. DBCC CALLFULLTEXT is one such >> internal >> system stored proc and if this is not working correctly, then all of your >> Full-text Search (FTS) functionality is suspect. >> >> As how to get out if this mess... That would depend upon the level of >> missing stored procs, if it is just MSSearch / FTS, you can use the >> procedures in the following KB article to manually re-install FTS / >> MSSearch: >> >> >> 827449 How to manually reinstall the Microsoft Search service for an >> instance of SQL 2000 >> http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 >> >> Hope that helps! >> John >> -- >> SQL Full Text Search Blog >> http://spaces.msn.com/members/jtkane/ >> >> >> >> "Support" <Support@discussions.microsoft.com> wrote in message >> news:255D5646-23E9-4DA0-B11E-BC1AE0AE091C@microsoft.com... >> > Hello: >> > running SQL2000 SP3 (8.00.818) >> > first >> > 1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we >> > noticed several system stored procedures were missing, including, >> > master..sp_fulltext_table >> > --I found a copy on our test machine and transfered it to production >> > server >> > where it is now seen as dbo owner but not a system table rather a user >> > table.... >> > 2) when running... >> > >> > EXEC sp_fulltext_table 'DOC', 'create', 'DOC', 'indx_intDOCunid'I get >> > Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_table, Line >> > 122 >> > Incorrect DBCC statement. Check the documentation for the correct DBCC >> > syntax and options. >> > >> > .. which is: >> > -- ADD TO CATALOG >> > DBCC CALLFULLTEXT ( 5, @ftcatid, @objid ) -- FTAddURL( @ftcatid, >> > db_id(), >> > @objid ) >> > >> > QUESTION: how do I get out of this mess. >> > Thanks >> > Terry >> >> >>
Don't see what you're looking for? Try a search.
|
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
| home · blog · groups | Questions? Comments? Contact the dn |