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

From: Pleo (rx8_at_hotmail.com)
Date: 10/17/05 

Date: Mon, 17 Oct 2005 17:16:46 +0800

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: Lost Login Name on Backup
    ... Read about sp_change_users_login in Books Online. ... Tibor Karaszi, SQL Server MVP ... does not have a Login Name when I select Users. ...
    (microsoft.public.sqlserver.server)
  • Re: Is there a way to show all the last user names used?
    ... Actually Bill I believe he's referring to the login so the user name file ... > which would record every NEW username used. ...
    (microsoft.public.windowsxp.general)
  • Re: New User causes Cannot resolve collation conflict error
    ... > Anthony Thomas ... > Tibor Karaszi, SQL Server MVP ... >> this case) or when you're adding a new login to the server? ...
    (microsoft.public.sqlserver.server)
  • Re: Lost Login Name on Backup-Thanks
    ... > Tibor Karaszi, SQL Server MVP ... does not have a Login Name when I select Users. ... Without this login I can't get an ASP application to work. ...
    (microsoft.public.sqlserver.server)
  • XP Logon Prompt
    ... Anyone have any ideas on how to change the login box for XP? ... The box I am referring to is the one that shows after Ctrl-Alt-Del. ... of Username and Password. ...
    (microsoft.public.windowsxp.help_and_support)