Tchater maintenant avec le support
Tchattez avec un ingénieur du support

LiteSpeed for SQL Server 8.8 - Configure Log Shipping 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

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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation