Unsolved
This post is more than 5 years old
2 Posts
1
4465
Sql Server Management
Hi All,
I am in a situation where I need to find the Changes happened to the database using Sql Server Management Studio Only and not from any Application.
Eg: Changes happened to the Stored Procedure,and Views and functions.
And wanted to track 'when' and 'who' made the change and if needed restore old data.
Kindly let me know if any third party tools are available in the market for this
Thanks,
theflash1932
7 Technologist
7 Technologist
•
16.3K Posts
0
August 23rd, 2014 08:00
In newer versions of SQL Server, you can enable auditing/tracking, as long as you have proper networking credentials for your users and adequate privacy (no sharing passwords, generic users, etc.). They might exist, but I don't know of any third-party tools.