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?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.