hmmmm....what happens if you remove the object_id(..) from the IF statement and replace it with a variable containing the object ID?

-Mike

>Hello Group.
>
>
>I used the build SQL Script option in the Enterprise Manager in SQL Server 7.0 and tried to run the script on a
>SQL 6.5 Server.
>
>The following code causes the errors at the bottom.
>
> 1 if exists (select * from sysobjects where id = object_id('dbo.sp_create_transfer_tables') and type = 'P'
> 2
> 3 drop procedure sp_create_transfer_tables
> 4 GO
> 5
> 6 if exists (select * from sysobjects where id = object_id('dbo.sp_update_careercenter') and type = 'P'
> 7
> 8 drop procedure sp_update_careercenter
> 9 GO
>10
>11 SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
>12 GO
>
>Gives the following errors when I try to run it on the SQL 6.5 Server
>
>Server: Msg 156, Level 15, State 1, Line 3
>Incorrect syntax near the keyword 'drop'.
>Server: Msg 156, Level 15, State 1, Line 4
>Incorrect syntax near the keyword 'drop'.
>Server: Msg 156, Level 15, State 1, Procedure sp_create_transfer_tables, Line 7
>Incorrect syntax near the keyword 'drop'.
>Server: Msg 156, Level 15, State 1, Procedure sp_create_transfer_tables, Line 12
>Incorrect syntax near the keyword 'drop'.
>
>Is there any way I can look at the SQL Server 6.5 Databases from SQL Server 7.0?
>
>Thanks
>Jim