Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Microsoft Dynamics GP DBA » All Tags » DBA » SQL Code

Browse by Tags

Related Posts

  • Blog Post: Cleaning up after a Payroll Error

    John Lowther
    If during the Payroll Process the Payroll Clerk gets an error to the effect of "an Open Operation error, a Get/Change error, or a Save Operation error " Then give these scripts a try: --Find let us find out where the error actually is: -- I like to know what I am about to delete! Select * From...
    on 20 Aug 2012

  • Blog Post: Alerts: 401k Setup

    John Lowther
    For years I have been writing alerts to let either myself of someone else know that there is a problem somewhere so that it can be fixed before it becomes a major issue. Now, over the years I have boiled my alerts down into a few generic types. And while I will keep you guessing as to the types of alerts...
    on 18 Jul 2012

  • Blog Post: SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs

    John Lowther
    Check out Sivakumar's post on SQL Script for Account Level Security till later,
    on 13 Jul 2012

  • Blog Post: Deadlocks caused by Implicit Conversion

    John Lowther
    Sans SQL has a good post on how implicit Conversion can call deadlocks in SQL Server. Check out their post at Sans SQL: Deadlock - Implicit Conversion I would also like to thank Vaidy for letting us know about this in his post Implicit Conversions Causing Deadlocks in SQL Server . Till later,
    on 29 Jun 2012

  • Blog Post: Using Lookups in GP Reports Viewer to make parameter selection more user friendly | Victoria Yudin

    John Lowther
    Victoria Yudin takes a look at using data lookup as parameters for reporting. See her post for details Using Lookups in GP Reports Viewer to make parameter selection more user friendly till later,
    on 31 May 2012

  • Blog Post: Single Insert with Union versus Multiple Inserts

    John Lowther
    This is an addendum to the Getting Data from Point A to Point B series. Wow, has it been that long since I first thought about writing this post? I wonder if work as many hours a week as I do has anything to do with that. J Anyway, as I promised longer ago that I care to admit, in this post we...
    on 10 May 2012

  • Blog Post: Problem with SQL Server 2008 and Exchange 2010

    John Lowther
    First please keep in mind that I know almost nothing about Exchange or how it works. The parts about Exchange that I will be discussing I am just paraphrasing from my Exchange Server Admin. Here is what happened: For years we have been using Exchange 2003 with no problems. And for years I have had SQL...
    on 23 Apr 2012

  • Blog Post: Some great scripts that I recently found

    John Lowther
    A few days ago I was searching for something and ran across this post from Jivtesh Singh . One of the scripts that he points out is a post from Mariano Gomez and lets you search for all tables for columns with the same name. Another one is a stored procedure to search the entire database for a specific...
    on 10 Apr 2012

  • Blog Post: Best Jobs in America 2011 - Money Magazine on CNNMoney

    John Lowther
    Hey Folks, Considering that I wear multiple hats were I work, like most people these days, this years list of the Best Jobs in America does a person good. You can check out the Best Jobs in America for 2011 here: Best Jobs in America 2011 - Money Magazine on CNNMoney Till later & hope to see you...
    on 6 Mar 2012

  • Blog Post: Script History Table and Procedures

    John Lowther
    As I do a lot of Data Warehousing I am always concerned that the data warehousing process itself could possibly impact performance. In order to track the various data warehousing procedures and insure that they do not harm performance I came up with the idea of having a table that each procedure would...
    on 21 Feb 2012

  • Blog Post: Resetting the users passwords after updating your test system

    John Lowther
    Ok, when you have multiple test servers and you have to refresh them more than just once in a while, or if you only have one test server but lots of users, resetting everyone’s password can become a pain point fairly fast. Now, mind you, I actually do like the way Dynamics GP handles security....
    on 17 Feb 2012

  • Blog Post: Where to put “my” stuff?

    John Lowther
    It has been a while since my last post as I have been really busy, but as I sit here during an install staring at a blue bar slowly going across the screen, I might as well multitask. So, as a DBA we are constantly getting this stored procedure from here or that one from somewhere else, all of which...
    on 1 Feb 2012

  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 6

    John Lowther
    Ok, now that I gotten a few unrelated things out of the way, where was I? Oh yeah, getting data from my application databases into a single Stage 1 database. Now if you can remember back on Step 3 , I had created a single stored procedure named sjp_ImportData. That stored procedure was the one that...
    on 3 Dec 2011

  • Blog Post: Searching for Data (updated)

    John Lowther
    Now that I have finally gotten rid of my final SQL 2000 Server, I have updated my Data Search Script to take advantage of the VARCHAR(Max) data type. No more tables that is too wide for the @SQL variable. If you still have a SQL 2000 Server my old post is here . Here is the updated script: ...
    on 5 Oct 2011

  • Blog Post: Synchronizing Dynamics GP Test Databases from your Production System

    John Lowther
    I was replying to an email when it hit me that this information would probably help a lot of other people as well as the person I was replying to, so how about posting it instead. The question was how to keep multiple test servers synchronized with Production information. Now, reasons for having...
    on 29 Sep 2011

  • Blog Post: Using "Select *" in code examples on my blog post

    John Lowther
    A friend of mine pointed out that I really should not be using "*" in select statements and leaving out field names in Insert statements and that by doing so it might lead someone into bad habits, so I thought I would post this for everyone's understanding. As you may have noticed I...
    on 25 Aug 2011

  • Blog Post: Getting Data from Point A to Point B - Introduction

    John Lowther
    As I write my series on Creating an EDW for CBI I realized that I really needed to go into much more detail on getting data from Point A to Point B than that series allowed. So in this series I will concertrate only on that one small aspect of the different ways of getting data from one table to another...
    on 22 Aug 2011

  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 5

    John Lowther
    Before I start going into code, please allow me to explain a few details about my system. I have four company databases that I want to merge into one. I also want to take some tables and merge them into a single table. In addition, I want to do all of this without affecting the performance of Dynamics...
    on 22 Aug 2011

  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 3

    John Lowther
    Ok, now let us start moving some data around. I have looked at multiple ways of moving data everything from replication, log shipping, SSIS, and various others to writing T-SQL. However, as I am a T-SQL kind of guy and I really want the finite granular control that writing my own SQL scripts will give...
    on 22 Apr 2011

  • Blog Post: Searching for data

    John Lowther
    (Notice: I have updated this script for SQL 2008 the new post with the new code is here .) I have no clue where I found this piece of code, how many years ago it was, if I wrote it or if I got it from someone else, but when I cannot find where in a database something is this SQL script has never...
    on 5 Apr 2011