Incremental Output In QA And Writing To Files

Hi;

Before I start let me say I know this is a silly way to go about
things, but it is one of those "my company made me do it" things.

My company is in the process of ( finishing ) migrating from foxpro to
sqlserver.

They have a foxpro program that does a lot of various updates. I
would like to write a tsql script to replace it.

The trick is that the tsql script would have to have some procedural
programming artifacts that I don't think it has.

I/my company would like the script to generate output messages that
the user can see while the script is running. Everytime I have ran a
script in query analyzer I usually don't see the output ("print"
statemetns, etc ) until all of the work is
done. Is there a way to run thing so I can see the output statements
as the work is being done?

Can print statements work from within a tsql loop?

The other thing is that I/my company wants the tsql script to write
output messages to a log file while it is operating ( for error
checking and other logging).

Is this possible with tsql?

Thanks in advance for the info

Steve