SQL Naming Convention

• musa 84273

  SSC Rookie

  Points: 34

  More actions

  April 7, 2011 at 10:25 am

  #234413

  i would like to know which script do i use to rename user names from e.g john.munroe to johnmunroe in a multiple batch job.

  may you please assist?

  :-D:-D

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  April 7, 2011 at 2:03 pm

  #1308816

  To rename login someone to someone_else:

  ALTER LOGIN [someone] WITH NAME = [someone_else];

  To rename database user someone to someone_else in database some_database:

  USE [some_database]

  GO

  ALTER USER [someone] WITH NAME = [someone_else] ;

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato