LiteSpeed for SQL Server 8.9 - Integration with TSM Guide

xp_slsReadProgress

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:

• Syntax

• Examples

Syntax

EXEC master.dbo.xp_slsreadprogress
@database = 'database_name'

Examples

1. 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

2. 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

Related Topic

About Using Extended Stored Procedures