We have a challenge some one run sql script to update username on the database against master db now all the username on the master db have one common username.
Can someone please Help us we want to Update username column in the master database by selecting username from another database in XAUser table below is script that I tried but am struggling with update part to the master db.
What I have tried:
from DBLive.[dbo].XaUser X
set UserInit = UserInit
where UserID = X.UserID