June 1, 2007 at 7:27 am
Hi I have setup a snapshot job which creates a new table in the same database using an existing table.
I get the following job failure message
There is already an object named 'PKPS'in the database. [SQLSTATE 42S01] (Error 2714) Could not create constraint. See previous errors. [SQLSTATE 42000] (Error 1750). The step failed.
Please advice
June 1, 2007 at 7:33 am
You can't create a table with the same name. If you would like to take backup of tables daily or periodically then you can use the script written by me and posted @ my @ http://sugeshkr.blogspot.com
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 1, 2007 at 9:37 am
The error message is very clear. the table is having a constraint named PKPS and when you are again creating the table then it is also building the constraint and giving error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply