The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.

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.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |