How to get progress of sql query using ADO.Net
Posted on 2007-11-13
Is it possible to use ADO.Net to get the progress (ie % complete) of a sql query?
The query I am running is to backup a database
eg "backup database test to disk = 'D:\mssql\backup\test.bck'
As some backup/restores take considerable time, I wish to display some progress, but don't know how to go about getting sql progress information from the sqlcommand object.
I know its possible to get the progress using other .net libraries such as SMO, but I wish to restrict the usage to only ADO.Net and anything under system.data.
Any help would be much appreciated.