how to alter user name?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  August 31, 2011 at 1:02 am

  #256487

  Hi,

  Login Name - HWDATA

  User name - HWData

  I want to change the user like HWDATA. how to do that? already HWData has own schema some of the tables?

  Thanks

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  August 31, 2011 at 1:09 am

  #1375318

  It is very simple, go to SMS press F2 to rename and change to your desired name.

  Sorry my bad i did not go through the full question.