>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.

The proc that you're trying to create already exists in the database. You'll have to drop it first.

-Mike