Feature Inquiry

• Johnny B

  SSCrazy

  Points: 2965

  More actions

  March 11, 2013 at 5:14 pm

  #272101

  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