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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/17/05


Date: Mon, 17 Oct 2005 11:09:12 +0200

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

  • New Login Question
    ... I have been programming with Sql Server 2000 for 2-3 years ... I noticed that at the bottom of the New login dialog there ... One selects a database to log in to ... dropdown always has master listed. ...
    (microsoft.public.sqlserver.security)
  • New Login Question
    ... The database login ... >dropdown always has master listed. ... >what is the significance of the database dropdown on the ...
    (microsoft.public.sqlserver.security)
  • Re: Error 21776:
    ... you need to manually refresh the ... use master ... However, when I then click on the Login and check out the database access, ...
    (microsoft.public.sqlserver.security)
  • RE: Cannot log into default instance after changes to sp_configure
    ... previous login files... ... up the default database via SQL server management studio. ... to master for your login and then try again. ... a message saying that I would have to restart the MS Server agent. ...
    (microsoft.public.sqlserver.connect)
  • Re: Error 21776:
    ... use master ... exec sp_addsrvrolemember 'DOMAIN\ug_ITSec_SQL', 'securityadmin' ... Then after, trying to grant that new login db_owner permissions, for ... However, when I then click on the Login and check out the database access, ...
    (microsoft.public.sqlserver.security)