update SID directly

is it possible/advised to update the SID directly on syslogins and sysusers?

thanks
LVL 6
anushahannaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
owaisyahyaConnect With a Mentor Commented:
update sysusers set sid = '123' where name = 'USER01'
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I would not recommend doing so. sysusers is a system table, and the SID is used to link between other system tables ...
0
 
anushahannaAuthor Commented:
a3, is it safe to do on syslogins? there is a situation where need the logins to have same sid across 2 instances. if the logins have that sid, then i make sure user also gets that sid by the command: CREATE USER FOR LOGIN...
0
 
owaisyahyaCommented:
if you really want to update sid change it on both tables (syslogin and sysuser)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.