Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incorrect DBCC statement?

Status
Not open for further replies.
01310564

01310564

Programmer
Oct 9, 2003
96
GB
Hi

I have just upgraded to SQL 2000 from 7 everything has worked fine until i try to run sp_fulltext_database which produces an error:


Server: Msg 2526, Level 16, State 3, Procedure sp_fulltext_database, Line 46
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.


Any Ideas?

Cheers,

Hugh
 
Sort by date Sort by votes
Is Full-Text enabled on these DBs and was it enabled when it was running under SS7?

Thanks

J. Kusch
 
Upvote 0 Downvote
Did you look in the BOL to see the syntax/options for that command? Maybe you are missing a parameter or have one entered incorrectly.

-SQLBill

BOL=Books OnLine = MS SQL Server's Help
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

markdmac
  • Locked
  • Question
Need help replacing all instances of incorrect text 1
Replies
5
Views
106
markdmac
markdmac
NikeGuy23
  • Locked
  • Question
Incorrect Syntax near 'INDEX'
Replies
4
Views
113
NikeGuy23
NikeGuy23
bugulgad
  • Locked
  • Question
incorrect check sum reading a page
Replies
1
Views
78
bugulgad
bugulgad
lrdave36
  • Locked
  • Question
Will This Case Statement Work??
Replies
1
Views
44
SQLBill
SQLBill
bborissov
  • Locked
  • Question
Strange DB Statement after RESORE
Replies
3
Views
57
bborissov
bborissov

Part and Inventory Search

Sponsor

Back
Top