Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Feature Inquiry Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 5:14 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 24, 2014 7:37 AM
Points: 68, Visits: 61
Hello,
Does 2012 offer any feature which allows for the collection of Instance data across all my production installs? In other words, what is a good technique to centralize (for documentation)

All SSIS package (document only)
All Jobs and scheduales
All logins and database mappings
Instance configuration parameters

I can write SQL queries and run them on each server and centralize them manually...or I can deploy procedures an maintain those across all instances. But I'd like to do this with as little footprint as possible. Preferable none.

What I'd like, is a feature where one of my instances is a repository and collects this information from the servers I choose. Does this make sense? How are people doing this and is there something in 2012 to help.


SQL 2012 Standard VPS Windows 2012 Server Standard
Post #1429542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse