To use SQLSetSavepoint, you first need to load DatabaseLink using Needs["DatabaseLink`"].
A group of SQL commands grouped into a transaction will only take effect permanently when the transaction is committed. The transaction can be canceled or returned to a savepoint.