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