Roy Ashbrook

let go or be dragged
posts - 197, comments - 29, trackbacks - 8

January 2010 Entries

print commands to give a group dbo in all the sql dbs

something silly i need to do every once in a while and i forget how to do it. the double double single quotes always mess me up =P   sp_msforeachdb 'print ''EXEC ?.dbo.sp_addrolemember N''''db_owner'''', N''''<GROUPNAME>'''' '''

posted @ Tuesday, January 12, 2010 4:15 PM | Feedback (2) | Filed Under [ DBA ]

Powered by: