SQL Server - Dynamic Code Blocks (Page 2)

Dynamic Code Blocks

Sign in Subscribe

SQL Server

A collection of 32 posts

SQL Replication duplicate log reader in SQL replication monitor

It is upgrade time, Dynamics GP does not like schema objects bound by replication during upgrades. During version updates some tables are copied dropped and recreated, depending on what changes have been made to the schema. If replication is left running on a Dynamics GP company during the upgrade, then

SSMS locked / frozen after network disconnect or computer sleep

When both the following are true: * the machine is woken from sleep or the network connection has been interrupted to SQL server * SQL Server Managment Studio Activity Monitor was open on a tab somewhere in the editor deck in SSMS. -then It will be no longer be possible to interact

Microsoft Dynamics GP

SQL Server 2012 SP2 Replication Log Reader error v.11.00.5058

After moving Dynamics GP to a newly built server, using a back up and restore strategy, the Dynamics GP SQL replication kept causing problems. The following message drowned the error logs of the server. I ended up rebuilding replication configuration entirely to solve the issue, but there may be some

Microsoft Dynamics GP

Beware DEX_ROW_TS for data synchronisation

DEX_ROW_TS is a SQL server database field. It is found on sometables in Dynamics GP ERP system(since V10). The field contains a UTC timestamp that is “stamped” whenever that row in the database is changed, setting it to current time and date. A blog entry from David

SSIS Destination Locking

See Top 10 SQL Server Integration Services Best Practicesfor some useful information on making SSIS work better for you. Found this one when trying to work out the best values for preventing lock escalation in our SQL server when inserting lots of records into live environment. Setting small commit size

SQL Server 2005/2008 – its great

We upgraded our SQL server from 2000 to 2008 early this year and although I have been using 2005 for a while for Microsoft Dynamics GP, only the website really stretches my TSQL skills to the limit. I have a library of scripts that solve most problems or can be

Microsoft Dynamics GP

GP-Dynamics – Custom Programming a TSQL Collection

I stumbled upon this a new Dynamics GP site tonight, gp-dynamics.com. This site lists nearly one hundred useful SQL scripts to use when working with Microsoft Dynamics GP ERP system. I glanced down the list of scripts and dipped into some of them and it all looked like a