#Sql in money manager ex how to
#Sql in money manager ex zip file
#Sql in money manager ex manual

In the Authentication list, click SQL Authentication.ĥ. In the Server name box, type the name of the SQL Server.Ĥ. On the File menu, click New Trace… to open the ‘Connect to Server’ dialog box.ģ. Click Start, point to Programs, click Microsoft SQL Server 20xx (your version), click Performance Tools, and then click SQL Server Profiler.Ģ.

#Sql in money manager ex manual

To create a SQL trace, follow these manual steps:ġ.

Send this trace file to the Microsoft Engineer, along with the information of what version of SQL you are using, and the user ID you used when performing the steps in GP. Note: The trace file should be created at the location selected above. Use the White Eraser icon (looks like a piece of chalk) to clear out the trace at any time needed. (This is enabled if the trace is stopped.) Use the Green Arrow icon at the top to restart the trace.

use the Red Square icon at the top to stop the trace. Traces too large are often not efficient or helpful. Be sure to keep the trace file as small as possible and only capture the steps in Dynamics GP to reproduce the problem. Use the icons listed below to help you capture the trace. Click RUN to start the trace and the SQL Profiler window will open and the trace is now running. Note: All the fields in Method 2 will automatically be selected in the Events Selection tab.ģ. In the Events Selection tab, mark the SHOW ALL EVENTS checkbox and SHOW ALL COLUMNS in the lower right corner. Also uncheck Enable File Rollover option (Under SAVE TO FILE section).Į. (Should beging with 'MSGP' prefix.)Ĭ. Click to mark the SAVE TO FILE checkbox and browse to a location you would like to save the trace file to. Click the drop-down icon next to the USE THE TEMPLATE field, and scroll down to the end of the list and select the SQL trace template you imported in. In the Trace Properties window, enter a name for Trace Name as desired.ī. (Or you can do a Save|Save As and go to that location on double-click on the tdf file.) Then you should get a message that the tdf file was imported successfully. (Take note of the file name as this is the name for the template you will look for in SQL profiler.) Click Yes if prompted to overwrite. tdf file for your version and SQL Profiler will automatically open. In the zip file, click on the TRACETMPL folder and double-click on the.

#Sql in money manager ex zip file

Determine what version of SQL Server you have and double-click the link below to download the zip file of SQL templates. To use a SQL Trace template, follow these steps:ġ. The templates are pre-mapped for the fields noted in Method 2, so will save you some time from having to manually map the fields. Use either method below to gather the SQL Profiler Trace: METHOD 1 - Use a SQL Template (Note, you can use the same steps or selection of event classes for any version of SQL Profiler.)

#Sql in money manager ex how to

This article describes how to use SQL Profiler to create an SQL trace in Microsoft SQL Server 2005 or in Microsoft SQL Server 2008. Dynamics GP 2010 Dynamics GP 2013 Microsoft Dynamics GP 2015 Dynamics GP 2016 Dynamics GP 2018 Dynamics GP More.