Archive for 2008
New Year Wishes – Welcoming 2009!!!
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 stagnation on the activities because of the economic pull back in many parts of the [...]
December 31, 2008 · 
veeyeskay · 
No Comments
Posted in: General Topics, Miscellaneous Total Views: 420
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, execute the code given below: /*========================================================= NAME: Decrypt SQL 2000 stored procedures, functions, views, [...]
December 24, 2008 · veeyeskay · No Comments
Posted in: SQL Server, SQL Server 2005 Total Views: 2,091
Decrypt SQL 2005 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. To decrypt the SQL Server 2005 objects, you need to login to SQL Server 2005 into the DAC (Dedicated Administrator Control) access. SQL Server 2005 [...]
December 24, 2008 · veeyeskay · 16 Comments
Tags: DAC, SQL Decryption · Posted in: SQL Server, SQL Server 2005 Total Views: 9,616
Smartlist Builder Objects using SQL Tables and Views
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 need to consider when u create a smartlist builder object using SQL server tables and [...]
December 23, 2008 · veeyeskay · One Comment
Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 1,691
Clearing Invalid Company References from DYNAMICS database
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 in typical scenarios, when we need to remove the company from SQL Server, we remove [...]
December 22, 2008 · veeyeskay · No Comments
Posted in: Dynamics, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, System Total Views: 583
SQL Stored Procedures to get the GP Constant value from SQL Server
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 hard-coding these constants, we can fetch the value from SQL directly as these constants are [...]
December 15, 2008 · veeyeskay · No Comments
Posted in: Customizations, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 371
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
- 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 Capture_Logins.sql script to capture all SQL Server logins and password information. All Read the rest [...]
December 9, 2008 · veeyeskay · No Comments
Posted in: Dynamics, Great Plains, System Total Views: 1,278
Scribe – One Stop Solution for Configurable Data Integration
With the enhancements in web services for Microsoft Dynamics GP, integrating it with other applications become a critical necessity. Scribe – A tool which enables you to setup integrations between various back office and front office applications. Gone are the days when we need to write chunks of code in order to setup an integration [...]
October 4, 2008 · veeyeskay · Comments Closed
Posted in: Dynamics, Great Plains, Integration Total Views: 893
DynamicAccounting.net: Analysis Cubes, Clustered Servers, and …
The best source for understanding how to do this is here: http ://msdn.microsoft.com/en-us/library/ms345193(SQL.90).aspx. However, YOU MUST read the correction entitled “Corrections for registry keys and file system paths” at the bottom of … MBSGuru said..
August 19, 2008 · Dwight Specht · No Comments
Tags: analysis cubes, dynamics, environment, facebook, integration, jobs, mapping, support debugging tool · Posted in: Blogs I Follow Total Views: 101