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

[axtens]

G'day everyone

That's a space between the ticks.

It's all part of a longer script but seeing as the failure occurs on
line 1

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[config]') and OBJECTPROPERTY( id, N'IsUserTable') =
1)
drop table [dbo].[config]
GO

That's three lines only. Does it matter that they're in Unicode?

Any ideas?

Kind regards,
Bruce M. Axtens
Software Engineer
Strapper Technologies

[m.bohse]

Bruce,
are you sure this is the part which causes an error ? It works fine on
my system.
ou must realise that the line number is always relative to the batch.
After GO a new batch starts and any error in the first line of an
statement after GO would return an error for line 1.

Markus

[m.bohse]

One more thing I almost overlooked. The error message clearly says
Incorrect syntax near ' '
but the code lines you posted don't contain any empty string ' ', so
the error must be somewhere else.

Markus

[axtens]

Gentlemen,

Thank you for your replies. With ISQL resetting its line number every
"GO" the offending line could have been anywhere in a 123 line file.

What I ended up doing was creating two scripts from the original: one
to do the "DROP"s and the other to do the "CREATE"s. Both ran without a
hiccup.

Thanks for your time.

Kind regards,
Bruce M. Axtens
Software Engineer
Strapper Technologies