Using stored procedures in SQL Server

The following stored procedures in the SQL Server can be used for the specified purposes:

• NCR_TransactionSearchByCustomerInfo—use this procedure for searching customer information. For more information about using this stored procedure, refer to Searching for transactions.
• NCR_AnonymizeCustomerInformation—use this procedure for anonymizing customer information. For more information about using this stored procedure, refer to Removing customer data from transactions.

The NCR_AnonymizeCustomerInformation stored procedure is located in the NCRWO_Transactions database.