Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fcoreyesv
Starting Member
18 Posts |
 Posted - 2006-06-07 : 11:29:51
|
| HelloMy team is creating a program which eventually will reindex and shrink all the tables in a given database. We want to automate this process for the users of our software which do not have a network administrator in staff. We are planning to run oSQL from a wizzard and somehow get the results on a flat file to be able to audit the process. My question is how can I export the temporary table created for DBCC to a flat file? I have read how to create the TraceStatus tables and I know that their live is limited so I need to save that data somehow before the process ends.Any help will be greatly appreciated,Best regardsFrancois Rois |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-06-07 : 11:33:10
|
use BCP command line utility.Go with the flow & have fun! Else fight the flow  Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
 |
|
|
|
|
|
flat file from table