Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

SQL Enable Identity Insert

2 Posts 2 Posters 0 Views 1 Watching

Z Offline
Z Offline
Zeyad Jalil

wrote on last edited by

#1

HI All, I use import and export wizard in sql server 2008 R2 to transfer data from sql server 2008 R2 to sql azure, but when i transfer a tables that contains a identity column the option enable identity insert doesn't work right. Please help me to solve this issue.
L 1 Reply Last reply

0
Z Zeyad Jalil

HI All, I use import and export wizard in sql server 2008 R2 to transfer data from sql server 2008 R2 to sql azure, but when i transfer a tables that contains a identity column the option enable identity insert doesn't work right. Please help me to solve this issue.
L Offline
L Offline
Lost User

wrote on last edited by

#2

SET IDENTITY_INSERT[^]
1 Reply Last reply

0

Log in to reply