Search This Blog

Friday, December 3, 2010

How can set identity in table column SQL2008 when data exist in table

Set identity in SQL2008 table column when data exist in table.
1.export data from local server to other server.
2.when select table from one server to other server.
3.Edit mapping option in window.
4.Click this button open window have option Edit SQL.
5.Click EDit SQLand change shema of table and then ok.
6.befor this select enable identity insert/Drop recreate option also.








1 comment :

Anonymous said...

thanks a lot for help.....