Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Saving Definition Changes to tables with large amo

Author  Topic 

magmo
Aged Yak Warrior

558 Posts

Posted - 2013-11-08 : 14:10:28
Hi

I have a table with a large amount of data, I try to make a Bigint column a primary key and also "is identity" using sql server manager, but I get a "Saving Definition Changes to tables with large amounts of data" warning and then a timeout error. How can I get around this?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-10 : 01:48:11
instead try to do it from wizard try using ALTER TABLE syntax in ssms

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

magmo
Aged Yak Warrior

558 Posts

Posted - 2013-11-11 : 01:40:29
quote:
Originally posted by visakh16

instead try to do it from wizard try using ALTER TABLE syntax in ssms

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs





Yes that worked much better, thanks!
Go to Top of Page
   

- Advertisement -