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.
| Author |
Topic |
|
krajdba
Starting Member
43 Posts |
 Posted - 2007-08-10 : 09:47:44
|
| Hi How to ALTER a column of Indentity to make it NOT FOR REPLICATION.I have a table with 40gb data.Urgent please.Thanks & Regards-Rajesh.Raj. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-10 : 11:49:05
|
If you have SP4 this might work:alter table dbo.testtablealter column [id] add NOT FOR REPLICATION Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-08-13 : 06:05:22
|
| How do we do it for a existing column?Raj. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-13 : 11:29:15
|
| Did you even try it out?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-08-14 : 05:34:58
|
| Hi I am getting following error.....alter table dbo.icts_transactionalter column sequence add NOT FOR REPLICATION---------error---------------Server: Msg 170, Level 15, State 1, Line 2Line 2: Incorrect syntax near 'NOT'.Raj. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-14 : 12:07:13
|
| The syntax works only post SP4. What version of SQL are you running? You can also change it in design view, it will take a few minutes (or longer) depending on the load, your hardware.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
krajdba
Starting Member
43 Posts |
Posted - 2007-08-16 : 09:16:33
|
| Thanks for the helpRaj. |
|
|
|
|
|
|
How to alter a identity column