• adisql - Thursday, December 21, 2017 2:42 PM

    its returned data. and we are trying to find how those objects modified .

    Yes, it will, but it doesn't go back far. It's not a full history.

    If the changes aren't in the default trace, and you don't have custom monitoring or audits, then you will not be able to tell who made these changes.
    It's possible to narrow down the list of potential culprits. SQL doesn't revert changes by itself, so if the objects are an older version, either someone reverted them, or you're looking at the wrong server, and if someone did so, then they'd need permissions to modify the objects, which should eliminate most of your users. Ask the other admins and devs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass