my code stock.com

Snippet options

Download: Download snippet as printcmd_sp_addrolemember.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

use [master]

select 'exec sp_addsrvrolemember '''+name+''', ''sysadmin''' as cmd, 'sysadmin' as role, name from syslogins where sysadmin = 1 and name not like 'sa'
union all 
select 'exec sp_addsrvrolemember '''+name+''', ''securityadmin''' as cmd, 'securityadmin' as role, name from syslogins where securityadmin = 1
union all
select 'exec sp_addsrvrolemember '''+name+''', ''serveradmin''' as cmd, 'serveradmin' as role, name from syslogins where serveradmin = 1
union all 
select 'exec sp_addsrvrolemember '''+name+''', ''setupadmin''' as cmd, 'setupadmin' as role, name from syslogins where setupadmin = 1
union all
select 'exec sp_addsrvrolemember '''+name+''', ''processadmin''' as cmd, 'processadmin' as role, name from syslogins where processadmin = 1
union all
select 'exec sp_addsrvrolemember '''+name+''', ''diskadmin''' as cmd, 'diskadmin' as role, name from syslogins where diskadmin = 1
union all
select 'exec sp_addsrvrolemember '''+name+''', ''dbcreator''' as cmd, 'dbcreator' as role, name from syslogins where dbcreator = 1
union all
select 'exec sp_addsrvrolemember '''+name+''', ''bulkadmin''' as cmd, 'bulkadmin' as role, name from syslogins where bulkadmin = 1

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.