Activity overview
Latest activity by rgelb
How to create a snippet that uses table metadata?
I would like to write the following sql via a snippet: SELECT TOP 10 * FROM dbo.Documents d ORDER BY 1 DESC So to do this, I have a snippet: SELECT TOP 10 * FROM $CURSOR$ ORDER BY 1 DESCHowever, I ...
How to get SQL Prompt to add (NOLOCK) when inserting a join?
Consider the following snippet:When I select CustomerPerson from the dropdown, is there a way to get SQL Prompt to add it with (NOLOCK) statement? I've looked through options and haven't found any...
Ants Performance Profiler 10 says Trial Expired.
I downloaded Ants Performance Profiler 10 to try it out. However, it gives me this error.
How to profile a website that has custom applicationhost.config?
I have Ants Profiler 8.6 (though I have no idea how to do this on the current version either). I have a solution in VS2017 that has
several web applications (some are webforms, some are just api ...
How to profile a website that has custom applicationhost.config?
I have Ants Profiler 8.6. I have a solution in VS2017 that has several web applications (some are webforms, some are just api end points) with a custom applicationhost.config in the %solutionDir%\...
How do I find which account the product was purchased with?
I have a RedGate product and a serial number. I've had it for a good long while. I've been thinking about upgrading it but I can't figure out which account or email address it was purchased with....
Michael Clark wrote: »
Would it be possible to update to the latest version SQL Prompt 9.0.6?
Unfortunately, I do not have the license to do so. However, a colleague of mine found a workaround. Add TrustServerCertificate=True to the Additional Connection Parameters tab in the Connect to Server dialog. / comments
Michael Clark wrote: »
Would it be possible to update to the latest version SQL Prompt 9.0.6?
Unfortunately, I do not have the license to do so. However, a colleague of mine found a workarou...
Don't get intellisense due to login error. Why?
I get intellisense for every other server in the enterprise, except for this one. The SqlPrompt/Help/Show Log menu yields the error below.
I can login to the box fine in SSMS and can run queries n...
Yes. I have the PDB. / comments
Yes. I have the PDB.
@Jessica R I think I figured it out. Placing my assembly into LineLevelBlackList.xml was not necessary. Neither was increasing permissions on my assembly in AssemblyInfo.cs I just added HtmlAgilityPack into the file and that did the trick.
The odd thing is that I do not have source code for this assembly. It's an open source library and I was just referencing the DLL.
My LineLevelBlackList.xml now has these entries:
<!-- Assemblies with known issues -->
<assemblyName>Newtonsoft.Json</assemblyName>
<assemblyName>log4net</assemblyName>
<!-- Add your assemblies to blacklist below this line -->
<assemblyName>HtmlAgilityPack</assemblyName>
Perhaps you should add HtmlAgilityPack to the list of assemblies with known issues. / comments
@Jessica R I think I figured it out. Placing my assembly into LineLevelBlackList.xml was not necessary. Neither was increasing permissions on my assembly in AssemblyInfo.cs I just added HtmlAgi...