3 suggestions to consider for SQL Server:
You can detect any ddl changes by using trace file. below is script to get changes.
te.name AS eventtype
SELECT TOP 1
WHERE property = 2
INNER JOIN sys.trace_events as te
ON t.eventclass = te.trace_event_id
You can detect any modification on table and stored procedure using this script:
FROM sys.objects AS SO
INNER JOIN sys.schemas AS SS
ON SS.schema_id = SO.schema_id
WHERE DATEDIFF(D,modify_date, GETDATE()) < 50
AND TYPE IN ('P','U')
Additional queries and event id definitions to further customize what object changes you are interested in can be found in Pinal Dave's blog in the link "SQL SERVER - Who Dropped Table or Database? - SQL Authority with Pinal Dave"
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.