Viewing 2 posts - 1 through 2 (of 2 total)
Maybe you could solve the ID problem using a sequence in the master database, that you query before adding a new row on the remote databases?
https://msdn.microsoft.com/en-us/library/ff878091.aspx
Regards
Marius
March 21, 2016 at 3:06 am
#1866387
Why not use sp_help_revlogin (https://support.microsoft.com/en-us/kb/918992), which works when importing/moving users to SQL 2014.
// Marius
August 18, 2015 at 4:35 am
#1820652