Here is an example of how to use the sp_msforeachtable stored
procedure
to
bcp out data for each table:
sp_MSforeachtable c:\? /U <user name /P <password> /S <server name> /c'" |
For more information on sp_msforeachtable, please read the archived article.