Saturday, February 25, 2012

Distribution DB

HI all:
How to use query to get Distribution DB name ?
Cheers
Nick
sp_helpdistributiondb
"nick" <fsheng@.ebreathe.co.nz> wrote in message
news:eb3waFjZFHA.1512@.TK2MSFTNGP10.phx.gbl...
> HI all:
> How to use query to get Distribution DB name ?
>
> Cheers
> Nick
>
|||thanks
also i worked it out another way to get distribution info is that select *
from msdb.dbo.MSdistributiondbs
Cheers
nick
"Khooseeraj Moloye" <rkmoloye@.hotmail.com> wrote in message
news:OH1gszjZFHA.3488@.tk2msftngp13.phx.gbl...
> sp_helpdistributiondb
> "nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:eb3waFjZFHA.1512@.TK2MSFTNGP10.phx.gbl...
>

No comments:

Post a Comment