Re: Old Users / New Domain - Any way to directly update SYSXLOGINS
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 14 Dec 2005 09:23:22 +0200
What is the version of SQL Server?
Take a look at sp_change_users_login in the BOL
"MSSQLServerDeveloper" <MSSQLServerDeveloper@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:CC69F7B5-2B63-4C12-AF93-D883BB692B28@xxxxxxxxxxxxxxxx
> FIRST - I already know I it is not recommended to directly update systems
> tables - no need to remind me. That being said, here is the scenario. I
> have a bunch of users who are switching from one domain to another.
> EXAMPLE
> login -
> myco.us.east\joe should NOW be myco.us.west\joe
> So, is there any easy way to just change the LOGIN name. I know that
> SYSLOGINS is a view and that SYSXLOGINS is the root table. Problem is
> that
> NAME in SYSXLOGINS doesnt seem to reflect the login name, rather the user
> name. It would be great is I could just change the login name via SQL -
> Any
> ideas on this?? Exactly what columns and where?
.
- Prev by Date: Re: Cant create diagram of exiting database
- Next by Date: RE: How do you update the SQL Server Agent's SysAdmin Password
- Previous by thread: Cant create diagram of exiting database
- Next by thread: Re: Old Users / New Domain - Any way to directly update SYSXLOGINS
- Index(es):
Relevant Pages
|
|
