Home Forums SQL Server 2005 Administering sqlstate 5001 error "There is already an object named PKCURSOR in the database" RE: sqlstate 5001 error "There is already an object named PKCURSOR in the database"

  • execute select * from sysindexes where name ='PKCURSOR' to see whether you have PKCURSOR already in your database or not. Please do this before you try to run script mentioned. If it returns you row that means you need to change constraint name to something else.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]