Hi,

I'd like to use a result of dbcc checkDB of a server A in a DTS
package of a server B.
I want to store the result in a txt file.

How to create this package ?

(i'm beginner in DTS)

If you execute this

dbcc checkdb('pubs') with tableresults

it returns the results in a table. You can then put these into a text file.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Thierry" <sch_th (AT) yahoo (DOT) fr> wrote

It's exactly what I need !!!
Where have you found "with tableresults" commands ??

I will need some other one later.



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

In BOL,

It isn't specifically listed in the page

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_dbcc_00gy.htm

But if you look here

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_dbcc_217n.htm

it states that many of the DBCC commands support WITH TABLERESULTS


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Thierry" <sch_th (AT) yahoo (DOT) fr> wrote