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

Manage, Control, store changes done to SQL Server Expand / Collapse
Author
Message
Posted Friday, January 21, 2011 9:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 08, 2013 2:03 AM
Points: 33, Visits: 108

I would like to know any software/process from Microsoft or third party that have the capability to manage, control and record changes (Keep history) of SQL Server/Instances, databases over a period of time.

Please share a URL or tool name; suggest me.
Post #1051909
Posted Saturday, January 22, 2011 7:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:15 PM
Points: 5,473, Visits: 23,560
Look at this product by REDGATE SOFTWARE

http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=sqlsourecontrol&gclid=CMT63JWCzqYCFYnd4AodK3UPGw


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1051953
Posted Saturday, January 22, 2011 6:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 16, 2013 6:59 PM
Points: 168, Visits: 350
are you talking about DDL & DML changes to the sql data or change to the actual server, such as a new user has been added, timeout connections setting has been modified?

DDL & DML changes you can capture with sql profiler, look into default trace and expand on that

for the actual change, you might need to write up some of your own code in c# or c++ or buy a 3rd party software.


-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool :.
Post #1052008
Posted Monday, January 24, 2011 7:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 08, 2013 2:03 AM
Points: 33, Visits: 108
Thanks.

Yes, I need to track changes to actual server and collect statistics like # users sessions/hour, locks/hour, SELECT/hour, time outs/hour, update/hour, adding new users, database growth/day, etc.,

Please suggest me a tool which can capture all these details.
Post #1052348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse