Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Microsoft Dynamics GP DBA » All Tags » FYI » Dynamics » 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: 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: 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: 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