Viewing post 1 (of 1 total)
That script doesn't actually work. But here is one that will:
exec sp_msforeachdb 'use [?]; CREATE USER [UserName] FOR LOGIN [UserName];EXEC sp_addrolemember db_datareader, [UserName]'
February 21, 2013 at 9:42 am
#1590036