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