Roy Ashbrook

let go or be dragged

posts - 189, 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)

«January»
SunMonTueWedThuFriSat
272829303112
3456789
10111213141516
17181920212223
24252627282930
31123456
About
  • Contact
  • Login
Archives
  • April, 2013 (2)
  • March, 2013 (7)
  • February, 2013 (2)
  • January, 2013 (5)
  • June, 2012 (1)
  • April, 2012 (1)
  • January, 2011 (2)
  • September, 2010 (2)
  • August, 2010 (5)
  • July, 2010 (3)
  • June, 2010 (8)
  • May, 2010 (3)
  • January, 2010 (1)
  • November, 2009 (1)
  • October, 2009 (3)
  • September, 2009 (1)
  • May, 2009 (3)
  • March, 2009 (1)
  • January, 2009 (1)
  • September, 2008 (1)
  • August, 2008 (2)
  • July, 2008 (3)
  • June, 2008 (2)
  • April, 2008 (1)
  • March, 2008 (6)
  • February, 2008 (8)
  • January, 2008 (3)
  • December, 2007 (3)
  • November, 2007 (4)
  • October, 2007 (3)
  • August, 2007 (1)
  • July, 2007 (19)
  • June, 2007 (13)
  • May, 2007 (21)
  • April, 2007 (3)
  • March, 2007 (33)
  • January, 2007 (1)
  • December, 2006 (5)
  • November, 2006 (2)
  • October, 2006 (3)
Post Categories
  • DEV
  • SA
  • ARCH
  • DBA
Syndication:

RSS ATOM

 

© Roy Ashbrook

Theme by PiyoDesign. Valid XHTML & CSS.