Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

print command Expand / Collapse
Author
Message
Posted Tuesday, February 24, 2004 4:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 27, 2008 4:29 AM
Points: 10, Visits: 3

with the print command a value or variable is returned on the screen at a certain point in a statement, is there a way of forcing the print statement to populate a text file for logging purposes

 

Post #101898
Posted Tuesday, February 24, 2004 5:17 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Yesterday @ 3:54 PM
Points: 8,369, Visits: 733
No. You could try inserts to a logging table or use sp_oa... items to call and talk to a text file to write data to (creates a high failure point thou as if it fails it rolls back). What is your hope to accomplish.


Post #101909
Posted Tuesday, February 24, 2004 6:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 27, 2008 4:29 AM
Points: 10, Visits: 3

the purpose is to have a log file record of the steps parsed in a TSQL statement so that a record is kept of the process, this way there is a tangible file of what a successful run should be so that comparisons can be made without having to watch query analyser. ISQLW goes part of the way with the output switch but the detail is not good enough, i need it to record text that I want in the file, so that i have a benchmark log file.

thanks

Post #101931
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse