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 |
|
m.yazdian
Starting Member
3 Posts |
 Posted - 2012-08-04 : 04:55:46
|
| When we import or export a table from sqlserver database to another table in sqlserver database, the "identity specification" switch to NO from YES.therefore we try to switch back from NO to YES but a message appears in sqlserver, indicating that:"Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-create or enabled the option Prevent saving changes that require the table to be re-create."So what should I do to have identity specification to remain YES or I be able to switch it from NO to YES.Thank you. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-08-04 : 05:20:06
|
HOW are you importing the data?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
m.yazdian
Starting Member
3 Posts |
Posted - 2012-08-04 : 06:59:08
|
quote:
Originally posted by SwePeso
HOW are you importing the data?
N 56°04'39.26"E 12°55'05.63"
Database / All task / Import data / select database source / select database destination / select copy data from one or more tables or view |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-08-04 : 13:37:40
|
| Create the table first with Identity, and then import into that table with Identity Insert ON.-Chad |
|
|
|
m.yazdian
Starting Member
3 Posts |
Posted - 2012-08-05 : 00:38:07
|
quote:
Originally posted by chadmat
Create the table first with Identity, and then import into that table with Identity Insert ON.-Chad
Hi chadmat,Thank you very much for your answer.I should select checkbox (Identity Insert ON) before import table from the source database. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-08-05 : 04:43:37
|
You can ONLY do that if the target table already has an identity column.The checkbox then uses the column value in the file as identity value, instead if the autogenerated value from the table.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
identity specification