Post reply

current status of copy (trigger prob)

  • October 22, 2002 at 11:45 pm

    #58600

    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.

  • October 23, 2002 at 4:07 am

    #439196

    If you are using batchsize then the data will be commited after this number of rows so you could monitor the number of rows in the table, using sp_spaceused.

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply