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