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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2008-04-09 : 05:32:55
|
| Hi all,Have anyone faced the timeout issue when setting a IDENTITY property of a column to NO.Is there any way to resolve it ?Note : The table on which I'm doing the operation is having approx 50 million records.Thanks, Hariarul.I get the below error :'TrnBillDetail' table- Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 12:49:47
|
| Why are you modifying a table which has 50 million records? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-09 : 13:11:02
|
| You would probably be better off bcping the data out and in to a new table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
IDENTITY property & Timeout issue.