how to show progress percent

[lowiq]

I have a script file which do the replication and in the script there is a lot of table need to be addad as article.

So while use osql execute the script there would be cost a lot of time. What I want to do is show a dialog which could show the progress percent and the file name which is now being addad as article.

hwo can i use Transact-SQL to do this?

Thanks a lot

[rmiao]

Not as I aware of.

[lowiq]

In fact, now I want to build a setup program with InstallShield Profession and during the install, a replication should be done. The database which need to be replicated is very big. So I want to show a dialog which show the progress precent to improve the setup UI. It is not complex to show a dialog in InstallShield script. but I can not return the counter in the MSSQL script to the InstallShield script, when using the osql utility( like osql ... -i script file name ).
Could any one give me any suggestion?

[MAK]

Split that SQL file into 10 different files. Show 10% progress for every time when OSQL executes the file.

[lowiq]

Is there could be any other way?

spilt file seems rather inefficient