Home » Archives
New Year Wishes – Welcoming 2009!!!
Written on 31 Dec, 2008 at 18:05 in General Topics, Miscellaneous | viewed 1 views times | 0 Comments
Guys 2008 has been a an interesting one for me with lots of activities, and I hope it was indeed the same for all of you as well. Of course, towards the fag end of the year, there was a... (Continue reading)
Decrypt SQL 2000 Stored Procedures, Functions, Views, and Triggers
Note: This method has to be handled with utmost care only in critical situations, and my experienced database administrators to provide critical support services in case of a SQL emergency. In order to decrypt the objects in SQL Server 2000,... (Continue reading)
Decrypt SQL 2005 Stored Procedures, Functions, Views, and Triggers
Written on 24 Dec, 2008 at 23:00 in SQL Server, SQL Server 2005 | viewed 1 views times | 14 Comments
Note: This method has to be handled with utmost care only in critical situations, and my experienced database administrators to provide critical support services in case of a SQL emergency. To decrypt the SQL Server 2005 objects, you need to... (Continue reading)
Smartlist Builder Objects using SQL Tables and Views
Written on 23 Dec, 2008 at 9:28 in Dynamics, Great Plains, Smartlist Builder | viewed 1 views times | 0 Comments
Whenever we create a smartlist builder object using SQL tables and views, we need to be careful when exporting the same and importing it on to a test environment (or) the production environment. There are a few things which you... (Continue reading)
Clearing Invalid Company References from DYNAMICS database
Written on 22 Dec, 2008 at 15:23 in Dynamics, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, System | viewed 1 views times | 0 Comments
When we come across a situation where, we need to remove out a test company from a GP installation, the most common way by which this is handled is by removing the access to all users from the company. But... (Continue reading)
SQL Stored Procedures to get the GP Constant value from SQL Server
Written on 15 Dec, 2008 at 22:52 in Customizations, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | viewed 1 views times | 0 Comments
Many a times, we do many customizations in GP, using SQL stored procedures and triggers. During these customizations, we might need to use few (or) many of the constants defined in GP for the purpose of various manipulations. Instead of... (Continue reading)
How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server
Written on 9 Dec, 2008 at 8:22 in Dynamics, Great Plains, System | viewed 1 views times | 0 Comments
- Excerpts from the Knowledgebase Article in Partnersource 1. On the old server, copy the following Capture_Logins.sql script to the local hard disk. Click the following link to obtain the Capture_Logins.sql script: https://mbs.microsoft.com/fileexchange/?fileID=879594a6-60ee-421f-b6ab-4d77da3aba22 2. On the old server, run the... (Continue reading)