Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Could not run BEGIN TRANSACTION error - Nav SQL
anilkumar
Member Posts: 136
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 - ?
Thanks
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 - ?
Thanks
Anil Kumar Korada
Technical Consultant
Technical Consultant
0
Comments
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.
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
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