Viewing 3 posts - 1 through 3 (of 3 total)
u can move the login from one instance to another by executing execi sp_help_revlogin SP, followed by the sp_hexidecimal SP.
it ll move all the login from one server to...
July 2, 2010 at 1:11 am
#1188026
By running sp_who & Sp_who2 ,u ll get more clarity on this issue
July 2, 2010 at 12:50 am
#1188023
For enabling mirroring in SQLserver 2005 SP2 ,we need to add trace flan in startup option (try this -t(1400)),then restart the server u ll see mirroring happens.
July 2, 2010 at 12:38 am
#1188020