i have a table [dbo].[CustomerDetails]
having columns like Id, Name, PhoneNo, Email, Address, City, State
i created executed sp in db level and table level.
But its returning
All columns: Id,Name,Phone,Email,Address,City,State
I need to get only if any update or insert or delete happen only for Email and City
how to mention only particular column
Thanks in Advance.
What I have tried:
What I have tried:
Exec Sys.sp_cdc_enable_db
EXEC sys.sp_cdc_enable_table
@source_schema=N'dbo',
@source_name=N'CustomerDetail',
@role_name=null