problem with sp_fulltext_table

when i run

sp_fulltext_table test, drop

it gives me error

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'drop'.

if i give qualifide table name

sp_fulltext_table dbo.test, drop

then it gives me error

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

what could be the problem?

d_kamalAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
danblakeConnect With a Mentor Commented:
Try:
sp_fulltext_table 'dbo.test','drop'
0
 
illCommented:
-- input variables are varchar !

sp_fulltext_table 'test', 'drop'
0
 
danblakeCommented:
It is because the @action has to be quoted with ' ' identifiers...
so you may find you can just use:

sp_fulltext_table test,'drop'
0
 
danblakeCommented:
ill,

the name 'test' is input sysname data-type.
0
 
danblakeCommented:
sysname is a nvarchar


Often table names do not need to be fully quoted when passed to a stored procedure.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.