Re: How to change sql login username instead of create new one.

From: Gabi Tianu (gabi_tianu_at_hotmail.com)
Date: 10/20/05 

Date: Thu, 20 Oct 2005 09:51:36 +0300

Very good point Tibor. Any unsupported change to the system table allways
has to be done first in a test environment.

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:OIynWFU1FHA.916@TK2MSFTNGP10.phx.gbl...
> sysxlogins is the name of the table, and syslogins is a view. So, the only
> place where a change would be needed is sysxlogins. However, hacking
> system tables is not supported and Pleo would be on his own by doing that.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Gabi Tianu" <gabi_tianu@hotmail.com> wrote in message
> news:eS3wd$T1FHA.1108@TK2MSFTNGP14.phx.gbl...
>> Hi,
>>
>> Yes, you can rename a SQL Server Login. You have to manually change
>> values in master.dbo.syslogins and master.dbo.sysxlogins.
>>
>> Gabi Tianu
>>
>> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
>> news:uW5cTJ80FHA.916@TK2MSFTNGP10.phx.gbl...
>>> Hi,
>>>
>>> As Tibor mentioned; In SQL 2000 you can not rename a SQL Server Login or
>>> database user.
>>>
>>> Thanks
>>> Hari
>>> SQL Server MVP
>>>
>>> "Pleo" <rx8@hotmail.com> wrote in message
>>> news:ON0lytv0FHA.404@TK2MSFTNGP09.phx.gbl...
>>>> I'm not familiar sql. At enterprise server (sql2000) > security >
>>>> logins >
>>>> (want to change name here).
>>>> Anyway, I guess it can't be changed there. Thanks.
>>>>
>>>>
>>>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> ???
>>>> news:%23R4Ixpv0FHA.3068@TK2MSFTNGP10.phx.gbl ???...
>>>>> Can you explain what you mean by "change sql login username"? Are you
>>>> referring to the login name
>>>>> (in master) or the user name (in your database)? Anyhow, you cannot
>>>>> change
>>>> the name of a login or a
>>>>> user, You will be able to rename a user in 2005, not sure about login,
>>>> though.
>>>>>
>>>>> --
>>>>> Tibor Karaszi, SQL Server MVP
>>>>> http://www.karaszi.com/sqlserver/default.asp
>>>>> http://www.solidqualitylearning.com/
>>>>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>>>>
>>>>>
>>>>> "Pleo" <rx8@hotmail.com> wrote in message
>>>> news:eVAlmnv0FHA.2428@tk2msftngp13.phx.gbl...
>>>>> > As title, thanks!
>>>>> >
>>>>> >
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>

Relevant Pages

  • Re: OPENQUERY
    ... retrieved and stored by the driver for later retrieval by the application. ... When an application requests another row, the driver will not need to send ... "Tibor Karaszi" wrote: ... > Profiler in SQL Server) and see what is actually submitted to the AS/400. ...
    (microsoft.public.sqlserver.programming)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... Columnist, SQL Server Professional ... Tibor is correct, you need to add SET NOCOUNT ON at the beginning of your ... stored procedure ... > However, in my ASP code, I get an error: ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... Columnist, SQL Server Professional ... Tibor is correct, you need to add SET NOCOUNT ON at the beginning of your ... stored procedure ... > However, in my ASP code, I get an error: ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL hotfix version discrepancy
    ... Server regarding Client and Server, or it might be something parsed by some client tool...). ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Resultset from 6.5 compared to 2000
    ... tibor, that's a convincing argument. ... >cases in the old architecture. ... >Tibor Karaszi, SQL Server MVP ... >> specify the order by clause if one wanted rows sorted. ...
    (microsoft.public.sqlserver.server)