Returns a count of dbremote connections for a multiplex database. This is a function implemented as a stored procedure.
dbo.sp_iqmpxcountdbremote ( )
When dbremote is running, the result is 5 connections. The following ISQL statement returns results as a table:
select dbo.sp_iqmpxcountdbremote()
dbo.sp_iqmpxcountdbremote(*) |
|---|
5 |
You can also display the output as a table using the following SQL:
begin
declare dbremotes int;
set dbremotes = dbo.sp_iqmpxcountdbremote();
select dbremotes;
end
