Reads the progress of the current activity on a specified database and returns an integer (0-100) indicating the percentage completed of the current activity on the specified database.
This topic covers:
EXEC master.dbo.xp_slsreadprogress
@database = 'database_name'
Read the progress of the current activity at a specified database:
exec xp_slsreadprogress @database='Northwind'
This command returns the percentage complete, for example:
(1 row(s) affected)
96 percent completed
Query the progress of an activity based on the result returned (in this case print 'DONE' when the progress is 100 percent):
Declare @Result int
exec xp_slsreadprogress @database='Northwind',
@Percent = @Result output
if @Result = 100
begin
print 'Done'
end
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center