Posted by axtens on 11/08/06 08:55

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

• Next in forum: Re: SQL query filtering date field by today's date?
• Prev in forum: Re: prevent one single row from being updated
• Thread view: ISQL: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ' '

[Reply to this message]