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. Type the system administrator user name and the password, and then click Connect to open the Trace Properties dialog box. Key a trace name. Click the Events Selection tab, and then click to select the Show all events check box in the lower-right corner. Expand Cursors , and then click to select the following check boxes:.
Expand Errors and Warnings , and then click to select the following check boxes:. Expand Locks , and then click to select the following check boxes. Expand Performance , and then click to select the following check boxes:. Expand Stored Procedures and click to select the following checkboxes:. Do not click to clear the RPC: Completed check box. Click Organize Columns , and then make sure that the following columns appear in the Organize Columns dialog box:. Do not filter by user. We can do that on our end, as it is often helpful to see what else is running a the same time.
But make sure to indicate in your email which user you where using when you return the trace file to Microsoft. Or click the Green Arrow icon at the top of the trace. On the File menu, click Stop Trace to stop the trace. Or click the Red Square icon at the top of the trace.
Need more help? Expand your skills. Get new features first. Tuesday, November 18, AM. Here is the actual answer you were all looking for: The server you are connecting to is a Everything will work fine now.
Tuesday, September 14, PM. Friday, November 21, AM. Friday, November 21, PM. Thanks, Varsham. Wednesday, November 19, AM. Thanks Sreekar. Monday, December 15, PM. Wednesday, December 29, PM. Monday, August 22, PM. My thanks also to ChrisLawrence - it worked perfectly and saved me from more aggrevation trying to locate templates I'd thought I'd created. Friday, January 27, PM. This solution does not work for me. Right click on the newly created folder and from the popup menu, choose the New option, and then click the Template command, type the name for a new SQL template e.
Change the SQL variable items to parameters e. When the PersonInfo template is double-clicked on, will open a new query window with the code in it:. When opening the template via double-clicking or via the Open command from the popup menu, a new query will open and populate the query with the contents of the template file.
Making changes to that query will not affect the existing template. But, if the Edit command is used to make changes, any changes that were made will be saved for future use. When initiating the Specify Values for Template Parameters the parameters that need to be changed will be highlighted in the query window:. FirstName ,. LastName ,. EmailAddress , pp. EmailAddress ea. Person p.
0コメント