Could not run BEGIN TRANSACTION error - Nav SQL

anilkumaranilkumar Member Posts: 136
edited 2007-10-03 in SQL General
Hi Experts!

when I am creating a new purchase order, the following error message is appering on the screen:

The following SQL Server error(s) occurred while accessing the Purchase Line table:

3906,"25000",[Microsoft][ODBC SQL Server Driver][SQL Server] Could not run BEGIN TRANSACTION in database 'XXXXX' because the database is read-only.

What could be the reason - ?

Can any one help me - ?

Anil Kumar Korada
Technical Consultant


  • strykstryk Member Posts: 645

    Well, the answer is given in the error-message: The databse is in Read-Only mode. "Transaction" means actually changing data, which is not allowed.
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • WaldoWaldo Member Posts: 3,412
    What SQL Server version are you using?

    If you open Enterprise Manager (SQL 2000) or SQL Server Management (SQL 2005), you'll see that your database is in Read Only mode. You should be able to turn it off in the tool as well.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.