Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GOPI
Starting Member
6 Posts |
 Posted - 2003-01-16 : 20:46:21
|
| Hi,Can someone kindly explain me how to create a sql user/ windows exisitng user and adding him to some existing role without using the EM ie just using the script way?By the way, can some one tell me how to fix orphan users and what is the logic behind this? Are there any mappings between system related tables? Thanks in advanceRgdsGopi |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-01-17 : 04:50:54
|
| a 'forum search' on "orphan user" (all words option) will turn up many topics on the subject area....one of which may provide a solution for you is...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615reading the various topics will give you more insight into the causes of (and solutions to) the problem. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-17 : 07:42:30
|
quote:
Hi,Can someone kindly explain me how to create a sql user/ windows exisitng user and adding him to some existing role without using the EM ie just using the script way?
you can use sp_addlogin or sp_user . refer BOL for detaius.Expect the UnExpected |
|
|
|
GOPI
Starting Member
6 Posts |
Posted - 2003-01-17 : 15:23:19
|
| Thanks Andrew Murphy and Harshal.Helped me to fix the orphan users during upgrades.You all have a nice day Rgds Gopi |
|
|
|
|
|
|
User login related