Error Message:
The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.
The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.
Severity level:
10.
Description:
This informell error message appears when you use more than one BEGIN TRAN commands with the WITH MARK option.
Consequences:
Resolution:
Errors of the Severity Level 10 are generated by the user and can be fixed by the SQL Server user. Specifying the WITH MARK option multiple times is not necessary.
Versions:
All versions of SQL Server.
Example(s):
IF OBJECT_ID (‘dbo.T1’) IS NOT NULL
DROP TABLE dbo.T1;
GO
CREATE TABLE dbo.T1
(
c1 int NOT NULL,
c2 AS c1 * 10
);
BEGIN TRAN abc WITH MARK
BEGIN TRAN xyz WITH MARK
INSERT INTO dbo.T1 SELECT 1
INSERT INTO dbo.T1 SELECT 1
COMMIT TRAN;
COMMIT TRAN;
Remarks:
In the above example we try to use a BEGIN TRAN command with the WITH MARK option multiple times. This raises the informell error.