title: SQL Server whole database csv export
body: <p>A consultant employed by my client has asked for an export of the the first n rows (approx 30 or 40) of all the tables in one of our SQL Server 2000 databases in csv format, including column names on the first row.  The database has about 100 tables so I don't want to do this manually.  </p>
  
  <p>Can anyone recommend a script, tool or other approach that can do this quickly?</p>