Export Sysusers table from all databases to flat file?

• Steve1014

  SSC Enthusiast

  Points: 153

  More actions

  February 9, 2011 at 10:57 am

  #149888

  Hello,

  I need to export the contents of the sysusers table to a flat file for all databases on a number of SQL 2005 servers (for and audit request). Please tell me there's a scripted way to accomplish this as doing this through the GUI is very tedious and I frankly don't have the time.

  Thanks!

  Steve

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 9, 2011 at 11:42 am

  #1284729

  Check out Red Gate's Multiscript product (link at top of the page).

  Otherwise, take a look at sp_MSForEachDB. That'll probably get you most of the way there.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon