How to change SQL Collation for SQL Server 2008 R2
Have you ever been in a situation where you wanted to change the SQL Collation to match SQL Database Collation?? Last year I have posted a script that resolves this for SQL Server 2005, but the same syntax is not applicable for SQL 2008 R2, while investigating this I found the correct syntax that need to be used as below: ” E:SQLsetup.exe ” /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME= MSSQLSERVER /SAPWD= P@ssW0rd /SQLCOLLATION= Arabic_CI_AI /SQLSYSADMINACCOUNTS=” DAOUD-PCDAOUD ” E:SQLsetup.exe will need to be replaced with the locations of the SQL Server 2008 R2 setup.exe path. MSSQLSERVER represents the default instance, if you have a named instance this must be changed to hold the instance name
February 4, 2012 · 
· 
No Comments
Tags: Analytical Accounting, auto, colleague, Customizations, development, fun, knowledge, sql server, sql server 2008, virtual · Posted in: Blogs I Follow Total Views: 2
Down Under
˙ɐıןɐɹʇsnɐ ɯoɹɟ sıɥʇ buıʇsod ɯɐ ı ˙uǝǝɹɔs ɹnoʎ ɥʇıʍ buoɹʍ buıɥʇou sı ǝɹǝɥʇ ‘ʎɐʞo sʇı More updates to follow once I get accustomed to reading and posting from here. Posted from – Perth, Feb 2012.
February 4, 2012 · Jivtesh Singh · No Comments
Tags: Analytical Accounting, Customizations, development, dynamics, extender, georgia, great plains, jivtesh-singh, management, support debugging tool, technology, upgrade · Posted in: Blogs I Follow Total Views: 4
Give me 5–The Dynamics Promotion
For those who are still thinking about when to purchase Dynamics ERP’s, I wanted to remind you that the give me 5 promotion which will allow you to purchase 5 users for 3,000$ is around to expire, and you have less than 22 days to take the decision! Below what quoted from Microsoft Dynamics Website: Get 5 users for one low price To renew or not renew, that is the question. Your annual maintenance agreement is right around the corner. You know that the money you spend year after year provides little value and keeps you tied to software that hinders your business growth.
January 29, 2012 · · No Comments
Tags: Analytical Accounting, business, database, facebook, great plains, management, middle-east, promotions, reporting, security, sql server, utilities · Posted in: Blogs I Follow Total Views: 12
Before Yearend Closing Check – Retained Earnings Exception Report
It has been long time since I been an active online community member as before, as the day has only 24 hours and is really not enough for 45 customers with many GP issues, offline contribution, online community activities, my masters , family, and fun time!!! However, I am doing my best to recover and follow up with all these! As a start, I wanted to share one thing to be included in your checks before closing your financial year, if you have several currencies linked to your profit and loss accounts, you will need to make sure that all these currencies are linked to the retained earnings account, so the multicurrency management module can work this with no issues. If you forgot to do so, the system will generate the accounts along with the currencies not linked to the Retained Earnings in a report called “Retained Earnings Exception Report” and the report will be printed automatically. Nothing to be done from your side at this point as the system will affect the retained earnings with the amounts, but you need to validate your profit/loss balance and make sure that the RE account affected correctly
January 29, 2012 · · No Comments
Tags: Analytical Accounting, books, Customizations, facebook, integration, Inventory, management, Multicurrency, reporting · Posted in: Blogs I Follow Total Views: 14
Management Reporter 2012
Management Reporter 2012 Release Themes Most of you know me to be a fairly technical guy, so it must be quite an event when I get excited about a financial reporting product. My excitement stems from a couple of things I saw in an MVP Product Group Interaction session yesterday with the Dynamics Corporate Performance Management team: Management Reporter 2012 is simply THE BEST darn financial reporting product produced to date by Microsoft
January 27, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, article, development, Dex.ini, dynamics, integration, management reporter, reporting, roadmap, Sales Order Processing, sql reporting services · Posted in: Blogs I Follow Total Views: 20
Microsoft Dynamics Convergence 2012 sessions now published
Ok, they have been published for a few days now.
January 24, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, General Ledger, microsoft, microsoft office, Multicurrency, security, Smartlist Builder, support debugging tool, virtual, windows · Posted in: Blogs I Follow Total Views: 21
The Support Debugging Tool on Twitter!
As you know by now - hopefully you do – Build 16 of the Support Debugging Tool (SDT) has been officially released – see Support Debugging Tool Build 16 released over at Developing for Dynamics GP for release notes and new features. However, you may have noticed I have not posted anything about it (don’t worry, I am still friends with Musgrave). The reason for the absence of posts on the new SDT build obays to a few reasons: 1.
January 19, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, Dex.ini, Dexterity, dynamics, fixed-assets, georgia, Inventory, microsoft, middle-east, security, support debugging tool, windows · Posted in: Blogs I Follow Total Views: 17
Management Reporter: Server Error in Application "MANAGEMENT REPORTER"
Just recently, I fielded a question on an issue that was happening with a Management Reporter installation. The partner reported getting the following error (shown in the picture) when attempting to open the Management Reporter URL address: Server Error in Application “MANAGEMENT REPORTER” .
January 17, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, construction, desktop, dynamics, extender, General Ledger, microsoft, Multicurrency, sql server, virtual · Posted in: Blogs I Follow Total Views: 29
Everything Dynamics GP #50 !
In this edition, I recommend checking out two excellent articles by Mark Polino, looking at the last year and this new year. The 11 Biggest Microsoft Dynamics GP Stories of 2011 | MSDynamicsWorld.com Six Microsoft Dynamics GP Predictions for 2012 | MSDynamicsWorld.com Also check out the following post by Errol at the Dynamics GP Blog – Happy New Year with a NEW Statement of Direction This 50th edition of Everything Dynamics GP has been as elusive as 100th international century of Sachin Tendulkar . Now that I am finally getting this edition out, who knows, Tendulkar might reach his landmark in Perth as well. I hope he does, really, I am getting tired of hearing and reading about it everywhere.
January 11, 2012 · Jivtesh Singh · No Comments
Tags: Analytical Accounting, database, development, facebook, fixed-assets, funny, security, small-business, sql server, taxes, upgrade, videos · Posted in: Blogs I Follow Total Views: 57
Microsoft Dynamics GP Add-In for Microsoft Word not enabling despite several attempts to install
Just recently, I ran into a situation with the Microsoft Dynamics GP Add-In for Microsoft Word where, after following all the installation steps and on-screen prompts, I could not get the Microsoft Dynamics GP Templates section to show up under the Developer’s ribbon in Microsoft Word 2010. Microsoft Dynamics GP Add-In for Microsoft Word properly registered in Microsoft Word Microsoft Dynamics GP Add-In for Microsoft Word not registered in Microsoft Word The customer was also running a 32-bit version of Microsoft Office, clearly indicating that the issue was not related to the version of the Office product being ran - Word Templates are still not fully compatible with 64-bit Office platforms. A first troubleshooting step under these circumstances is to make sure that the Microsoft Dynamics GP Add-In for Microsoft Word is enabled under the COM Add-Ins window in Microsoft Word.
January 10, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, countries, Dexterity, dynamics, manager, Multicurrency, security, Smartlist Builder, windows, word templates · Posted in: Blogs I Follow Total Views: 24