maida_rh (1/31/2013)
Pk_violation when i tried to import data from current updated source database todestination database.
still you are not clear here , are you populating tables on destination side which already contain data then there is possibilty of PK violation. if possible(Be very very careful) that you can afford then truncate the table at dest. side and then populate them.
maida_rh (1/31/2013)
How can I resolve orphan login as ,already assiged a login password to that user ????
ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa
GO
see this http://msdn.microsoft.com/en-us/library/ms187359.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)