Monthly Archives: July 2015

Command Line Script to Open Ports for SQL Server

    @echo =========  SQL Server Ports  ===================@echo Enabling SQLServer default instance port 1433netsh firewall set portopening TCP 1433 “SQLServer” @echo Enabling Dedicated Admin Connection port 1434netsh firewall set portopening TCP 1434 “SQL Admin Connection” @echo Enabling conventional SQL Server … Continue reading

Posted in Uncategorized | Leave a comment

Dynamics GP 2015 Upgrade System Requirements

If you are upgrading to Dynamics GP 2015 make sure that you are at least on SQL Server 2008 R2 and running Windows Server 2012.Vince Stefanetti

Posted in Uncategorized | Leave a comment

How to Clear Stuck Users in ExactMAX 5

  Always use caution when editing live tables in MAX. On occasion a hard closure of MAX or a dropped connection can cause MAX to retain the user in the ERMUD table which is in the EXACTMAX master database. You … Continue reading

Posted in Uncategorized | Leave a comment

Setting Up SQL Database Email with a Google Mail Account

  If you need to use a Google Account for setting up email notifications on SQLServer make sure you use the 2 step security method. Login to the Google Account Go to Account Settings for the Account – Upper Right … Continue reading

Posted in Uncategorized | Leave a comment

Collation Sequence

  This defines how SQL Server will sort Case and Accents ( glyphs to determine pronunciation) and Kana (Japanese syllabic writing). Capitalization and the Diacritical ( Dia – through and krinein “to separate”) marks are included in sort considerations by … Continue reading

Posted in Uncategorized | Leave a comment

What does the Double Period Mean in T-SQL Script?

When a double period is used, as in:   ExactMAXSampleDB..Part_Master   This means the schema is inferred to be the default schema of the current login.   In most cases this will be .dbo. So instead of having to provide … Continue reading

Posted in Uncategorized | Leave a comment