Installed value from SP_GET_DISTRIBUTOR

Last Post 15 Mar 2010 07:35 AM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
15 Mar 2010 07:03 AM
How can I retrieve the Installed value from SP_GET_DISTRIBUTOR so that I can use it in a script?
gunneyk
New Member
New Member

--
15 Mar 2010 07:35 AM
The only way I know of is to insert into a table and get it from there.

DECLARE @Dist TABLE ([Installed] INT, [dist server] INT,[dist installed] INT, [publ] INT,[remote] INT) ;
DECLARE @Installed INT ;

INSERT INTO @Dist exec [sys].[sp_get_distributor] ;

SELECT @Installed = [Installed] FROM @Dist ;

SELECT @Installed ;


Acceptable Use Policy
---