SQL Server Status Callback

Is there anyway to get the current status of a long running SQL query using ADO with SQL Server 2000? During DTS Package execution, it gives the number of records copied, I am looking for a way to do this in my own applications.

Thanks a lot