cy.harrild (1/7/2008)
This is a great tool but i'm having a problem. It all works fine except that all the databases that the package finds throughout the network are listed against one server. Is this caused by the fact i'm building this on my workstation and not on the server?
I'm having the same issue as cy.harrild. My dbo.database_status table only has info for the server I'm running the package from, instead of info for all servers on this domain. Looks like the loop is working because I'm getting the same 12 lines repeating for each server. Just seems that the loop is not grabbing the next server name into the variable SRV_Conn each time. ANy thoughts?
Dave Coats