General information
Forum:
Microsoft SQL Server
Title:
Running SQL 7.0 Script on SQL 6.5 server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only