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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-07-29 : 23:06:38
|
| I was doing a "select into" using linked server.. this the error I get... while my research I got that number records was too much to handle... anyone has workaround ... thanks!The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 422227540443136. Dropping and re-creating the index may resolve this; otherwise, use another clustering key. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-07-30 : 07:53:42
|
| Hmm...how many records are we talking about when you do your select into?Mike"oh, that monkey is going to pay" |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-07-30 : 12:15:10
|
| I'm not 100% sure how you are using he linked server. So I'll jsut sya you need to be careful when using them. But, if you are jsut pumping data over I'd use SSIS, that way you can commit in batches. |
|
|
|
|
|
|
select into from huge table