Share via

Trace Sp in the Sql

Atefe Ramezani 20 Reputation points
2023-12-19T14:14:56.3266667+00:00

Hi

I have an Attendance software company which established for 1000 customers.

I need to Find out what changed in each part of my SP data. It should be noted that I have to run this tool in the customer environment. Do you know a tool for this?

SQL Server | Other
Accepted answer
  1. Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator
    2023-12-19T16:47:39.9833333+00:00

    Thanks for posting your question in the Microsoft Q&A forum.
    SQL Server provides Change Tracking stored procedures that provide an efficient data change tracking mechanism.

    https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/change-tracking-stored-procedures-transact-sql?view=sql-server-ver16

    Also, Look at schema comparison tools, such as those available in SQL Server Data Tools (SSDT), and commercial options like Red-Gate SQL Compare.

    https://dba.stackexchange.com/questions/48125/tracking-changes-in-stored-procedures-within-a-database

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.