how to find mamber name in sp_addrolemamber

Question

i need to add user for 'DatabaseMailUserRole' This Is a Query for add role sp_addrolemember @rolename = 'DatabaseMailUserRole' @membername = ' '; But what is @memberName and how to find my @membername

Nitin Sontakke · Answer

Use following command in SQL Server Management Studio to know your login name: select suser_sname()

Nitin Sontakke · Answer

While I am not 100% sure it would be any user name in current database as stated in help itself. This is a security feature. Typically you should have a separate user for such tasks and that user should be member of this role. This user could be a SQL Server user or a Windows user - if your server is configured for mixed mode authentication. This way other users (who are obviously are not member of this role) will not be able to send the mail (either deliberately or inadvertently). Hope you get the point.