hi all,
ok, here i explain my scenario . Actually i created a procedure say usp_bcp_in that is using 'xp_cmdshell' to run bcp. Since i am using Visual FoxPro at Client side i am excuting the above mentioned procedure (usp_bcp_in) using sqlexec. When i run the command i starts bcp as i wriiten in usp_bcp_in. As u must know that when i run bcp on command prompt of server, it displays a batch information above current rows copied, like 1000 default batch size give 1000 rows copied. I want this or some information, importantly ...while bcp is running, to appear at client (Visual fox Pro side) so that my client should at least know that bcp in running and the process has not got stuck! or it has so far copied that much of rows.... So this is where i think i can use trigger to updatte a counter somehow for each row inserted by bcp, i will be able to display the counter on client side. i hope this will explanation will definitly tell u about what i want excatly......
so am waiting eagerly for your comments....
Sabih.