You’re offline. This is a read only version of the page.
i'm setting up a new database and want to eliminate all the existing customers. is there a way to do a batch delete?
Fred
*This post is locked for comments
I have the same question (0)
Are you REALLY sure you want to do this?
BACKUP FIRST!!!
SO Admin | File | Connect |Query | New | type DELETE Customer and press the green arrow on the top
Now to clean up their history;
To delete all sales history, customer purchase history, purchase orders, and inventory transfers in the Store Operations database, follow these steps:1.In Store Operations Administrator, click Connect on the File menu, type the sa password, and then click OK.
2.On the Database menu, click Delete Transactions.
3.When you are prompted with a warning message in the Delete Transactions window that indicates that this operation permanently deletes all sales information from the database and leaves the item information intact, click Yes.
4. When you are prompted with a warning message in the Delete Transactions window that indicates that this operation permanently deletes all sales information, click Yes again.
5. When you are notified that all sales information is deleted, click OK.
6.After you delete the transaction history, compact the database before the size of the database is reduced. To do this, follow these steps:•On the Query menu, click New.
•Copy and then paste the following SQL statement into the New Query window.
DBCC SHRINKDATABASE (X)
Note Replace X with the name of the Store Operations database.
• Press F5 to run the statement.
BACKUP FIRST!!
Share
Report
All responses (
Answers (
13,382
