IMPORT ACCESS FROM SQL SERVER 2000
-
i import a huge database from access to sql server 2000, in Access database there were a field which is auto increment and primery key,but when i check SQL SERVER auto increment constraint not there and im not able to change data type to unique identifier field ,how i change it to auto increment? Rajith Alwis
-
i import a huge database from access to sql server 2000, in Access database there were a field which is auto increment and primery key,but when i check SQL SERVER auto increment constraint not there and im not able to change data type to unique identifier field ,how i change it to auto increment? Rajith Alwis
if it is an integer field, set the "identity" property to true and the "increment" property to 1. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer
-
if it is an integer field, set the "identity" property to true and the "increment" property to 1. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer
thanx Rob, earlier i didnt see the identity increment field its appear only when we set the identity property true, thanx Rajith Alwis