General information
Forum:
Microsoft SQL Server
Title:
Converting an SQL 7 script to 6.5
Hello Group,
I am trying to convert a script I created in SQL Server 7.0 to run on SQL Server 6.5. The scripts create stored procedures and views. This part of the script and the error messages have me confused. I created the scripts by using the Create SQL Scripts in SQL Server 7.0.
if exists (select * from sysobjects where id = object_id('dbo.jw1_distinct_suniq_Career') and type = 'P')
drop view dbo.jw1_distinct_suniq_Career
GO
CREATE VIEW dbo.jw1_distinct_suniq_Career
AS
SELECT DISTINCT stusched.suniq
FROM dbo.course INNER JOIN
dbo.trkcrs ON
dbo.course.crsuniq = dbo.trkcrs.crsuniq INNER JOIN
dbo.mstsched ON
dbo.trkcrs.trkcrsuniq = dbo.mstsched.trkcrsuniq INNER JOIN
dbo.mstmeet ON
dbo.mstsched.mstuniq = dbo.mstmeet.mstuniq INNER JOIN
dbo.stusched ON
dbo.mstmeet.meetuniq = dbo.stusched.meetuniq
WHERE (dbo.course.coursec LIKE '%t%') OR
(dbo.course.coursec LIKE '%CA%')
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO
ERROR MESSAGE:
Server: Msg 2714, Level 16, State 1, Procedure dbo.jw1_distinct_suniq_Career, Line 8
There is already an object named 'jw1_distinct_suniq_Career' in the database.
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