Modify the stored procedure to put all results into a table (or write a warpper procedure for that) then retrieve the complete result from the table. or modify the stored procedure and add a parameter (database id or name). Call it in a loop for each db separatelly and
save each one in a different file then concatenate files together like copy file1 + file2 + file3 final_file : I am using the script below and would like to save the results of the stored
: procedure to the file in DatabaseSave. This SP cycles through many
: databases but only the final one is written. Can I append to a file? : dim rows, number
: DatabaseConnect("ServerName")
: DatabaseRetrieve( "exec all_db_shrinkdatabase", rows)
: DatabaseSave( "d:\jobs\db audit\ShrinkDB.txt", "TXT",
: rows ) : Another possibilty would be to write the results to a table. How do I capture
: the results to use them with a DatabaseInsert command? : Thanks for the help! : Jason
|
