Post reply

Profiler User error mesaages

  • September 7, 2011 at 7:49 am

    #390356

    HI All,

    I am running a profiler with user error meessage event .

    I am getting the below errors :

    1. Changed database context to 'databasename1'

    2. Changed language setting to us_english.

    3. Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission.

    4. The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.

    Any one help me on the above issues .

    Thanks

    Lavanaya

  • September 7, 2011 at 9:38 am

    #1378066

    1. Changed database context to 'databasename1'

    It's not an error, it's an informational message fired whenever you change database context with USE DatebaseName. Nothing worth worrying about.

    2. Changed language setting to us_english.

    Again, an informational message.

    3. Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission.

    Ignore it, it's a well known error generated by poor queries in SSMS

    4. The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.

    Inspect the MSDTC log for more information. You should see what happened and why the transaction was cancelled.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • September 7, 2011 at 10:20 am

    #1378110

    Thanks Gianluca Sartori

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply