how can i send sp results to a text file

[korel038]

let's say that i am using query analyzer in a database called alfaoik...and i am running the sp_server info or the sp_helpfile on the mdf or the ldf file....
i want automatically using a command after running the sp and viewing the results to send them in a text file in c:\.....text1 for example...is that possible?
thanks in advance..
jstr

 

[MissyEd]

You can output the results via query analyzer into a text file. To do this click Query in the toolbar and selecting Results to file. Alternatively, use key combination CTRL+SHIFT+F.

Missy Ed - Project Manger - Bolton, UK

 

[cheyney]

Check this out:

http://www.sqlteam.com/item.asp?ItemID=4722

Cheyney

 

[korel038]

let's say that i have a database and i am using an update for it for my customers once a week...and i want at the end of it to see if there where any problems encountered....i want these answers sent to a text file by using a function or some sort to do that...

 

[korel038]

'**********************************************************************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'************************************************************************

Function Main()
DTSDestination("DhmIstApofMerMelID&quot = DTSSource("DhmIstApofMerMelID&quot
DTSDestination("DhmIstApofID&quot = DTSSource("DhmIstApofID&quot
DTSDestination("DhmIstApofMerMelMerida&quot = DTSSource("DhmIstApofMerMelMerida&quot
DTSDestination("DhmIstApofMerMelMelos&quot = DTSSource("DimMainID&quot
DTSDestination("DimStatus&quot = DTSSource("DhmIstApofMerMelMelos&quot
DTSDestination("DimEponymo&quot = DTSSource("DimStatus&quot
DTSDestination("DimOnoma&quot = DTSSource("DimEponymo&quot
DTSDestination("DimOnomaFather&quot = DTSSource("DimOnoma&quot
DTSDestination("DimOnomaMother&quot = DTSSource("DimOnomaFather&quot
DTSDestination("DimMainID&quot = DTSSource("DimOnomaMother&quot
DTSDestination("DiagrafDescr&quot = DTSSource("DiagrafDescr&quot
DTSDestination("ToposBorn&quot = DTSSource("DimDateDiagraf&quot
DTSDestination("etosborn&quot = DTSSource("DimDateSymban&quot
DTSDestination("DimEponFather&quot = DTSSource("ToposBorn&quot
DTSDestination("DimGenosMother&quot = DTSSource("DateBorn&quot
DTSDestination("DimSxeshID&quot = DTSSource("etosborn&quot
DTSDestination("KtIthag&quot = DTSSource("DimEponFather&quot
DTSDestination("Ithag&quot = DTSSource("DimGenosMother&quot
DTSDestination("DimKtIdiotDim&quot = DTSSource("DimSxeshID&quot
DTSDestination("DimEtosMar&quot = DTSSource("KtIthag&quot
DTSDestination("DimOtaMar&quot = DTSSource("Ithag&quot
DTSDestination("DimBathGamMale&quot = DTSSource("DimKtIdiotDim&quot
DTSDestination("DimBathGamFemale&quot = DTSSource("DimArMar&quot
DTSDestination("DimDateDilGam&quot = DTSSource("DimEtosMar&quot
DTSDestination("DimPraxiGam&quot = DTSSource("DimOtaMar&quot
DTSDestination("DimDateGamPolit&quot = DTSSource("DimBathGamMale&quot
DTSDestination("DimToposGamPolit&quot = DTSSource("DimBathGamFemale&quot
DTSDestination("DimDateGamThrisk&quot = DTSSource("DimDateDilGam&quot
DTSDestination("DimToposGamThrisk&quot = DTSSource("DimPraxiGam&quot
DTSDestination("DimDateGamPolitEtos&quot = DTSSource("DimDateGamPolit&quot
DTSDestination("DimDateGamThriskEtos&quot = DTSSource("DimToposGamPolit&quot
DTSDestination("DimOtaLixBorn&quot = DTSSource("DimDateGamThrisk&quot
DTSDestination("eMerida&quot = DTSSource("DimToposGamThrisk&quot
DTSDestination("DimDateDiagraf&quot = DTSSource("DimDateGamPolitEtos&quot
DTSDestination("DimDateSymban&quot = DTSSource("DimDateGamThriskEtos&quot
DTSDestination("DateBorn&quot = DTSSource("DimOtaLixBorn&quot
DTSDestination("DimArMar&quot = DTSSource("eMerida&quot
DTSDestination("DimBibliarioNo&quot = DTSSource("DimBibliarioNo&quot
Main = DTSTransformStat_OK
End Function