Home Forums SQL Server 2005 T-SQL (SS2K5) cannot insert duplicate key row in object 'tablename' with unique index 'indexname' RE: cannot insert duplicate key row in object 'tablename' with unique index 'indexname'

  • May 1, 2013 at 8:41 am

    #1611574

    VRT (4/28/2009)

    Please guide me yar. How to change the column size in query analyzer, not in SSMS?

    You can't alter a column that is part of the primary key or that is referenced as a foreign key by another table. You have to drop the primary key and foreign key(s) before you can alter the column.

    Jason Wolfkill