when parsing lin2world I get this error:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'if'.
Server: Msg 156, Level 15, State 1, Procedure lin_MoveCharCopyPledge, Line 18
Incorrect syntax near the keyword 'OPENROWSET'.
Server: Msg 170, Level 15, State 1, Procedure lin_MoveCharCopyPledge, Line 18
Line 18: Incorrect syntax near ''.
Server: Msg 156, Level 15, State 1, Procedure lin_MoveCharCopyPledge, Line 19
Incorrect syntax near the keyword 'as'.
Server: Msg 105, Level 15, State 1, Procedure lin_MoveCharCopyPledge, Line 21
Unclosed quotation mark before the character string '
exec ( @sql )
Here is my lin2world_20040609_all.sql file:
Line 1:
set @conn_str if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DB_BACKUP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
Line 18:
drop procedure [dbo].[TranLogBackup]
Line 19:
GO
Line 21:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dp_GetItemListByAccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
Please help me. Thanks in advance!