Converse agora com nosso suporte
Chat com o suporte

LiteSpeed for SQL Server 8.9.1 - 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

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação