Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Table import and creation problem on MSSQL2005
srle
Member Posts: 6
Hello,
Recently, we have migrated Navision SQL Server database to a new server. Server has MSSQL Server 2005 installed, while on "old" server MSSQL Server 2003 was used. Since that moment, we have problem with importing and creating TABLE objects in that database.
The following error occurs: 4628, "01000", [Microsoft][ODBC SQL Server Driver][Sql Server]The ALL permission is depreceated and maintained only for compatibility. It DOES NOT imply ALL permisssions defined on the entity.
However, all other object types could be created and imported without problem.
If someone experienced similar problem or has some advice, I look forward for reply.
Recently, we have migrated Navision SQL Server database to a new server. Server has MSSQL Server 2005 installed, while on "old" server MSSQL Server 2003 was used. Since that moment, we have problem with importing and creating TABLE objects in that database.
The following error occurs: 4628, "01000", [Microsoft][ODBC SQL Server Driver][Sql Server]The ALL permission is depreceated and maintained only for compatibility. It DOES NOT imply ALL permisssions defined on the entity.
However, all other object types could be created and imported without problem.
If someone experienced similar problem or has some advice, I look forward for reply.
0
Comments
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
If I remember correctly, for SQL2005, you should run 4.00 (preferrable SP3).[/b]
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
Try to test it with a 4.00Sp3 runtime ... There won't be any problems.
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
MSSQL 2005 is not supported by <4.00SP2 versions... (or SP3?)
Can you put [solved] in the subject?
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!