Forum Discussion
threw000
Jul 04, 2023Copper Contributor
SSMS Help - Capturing Changes in the data and recording
Hello Sorry in advance - I am new to SQL and SSMS. Please can I have some help with learning if the below is possible? I will have an SSIS package feeding data to SQL with the below table. Th...
olafhelper
Jul 04, 2023Bronze Contributor
threw000 , SSMS is just a tool, nothing else, the job is always done be the SQL Server database engine.
You can use a DML trigger to log changes, see
CREATE TRIGGER (Transact-SQL) - SQL Server | Microsoft Learn