Solved

update SID directly

Posted on 2011-03-15
4
1,027 Views
Last Modified: 2012-05-11
is it possible/advised to update the SID directly on syslogins and sysusers?

thanks
0
Comment
Question by:anushahanna
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
owaisyahya earned 250 total points
ID: 35141714
update sysusers set sid = '123' where name = 'USER01'
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 35142334
I would not recommend doing so. sysusers is a system table, and the SID is used to link between other system tables ...
0
 
LVL 6

Author Comment

by:anushahanna
ID: 35143727
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
 
LVL 2

Expert Comment

by:owaisyahya
ID: 35144404
if you really want to update sid change it on both tables (syslogin and sysuser)
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question