Search
-
Re: SQL code to find upper case values
you should use the SUBSTRING function: SUBSTRING (string, start, length) * string: can be a string, variable or column that you want to extract. * start: is an integer specifying the position where the substring should be returned from. Note that the first character in the string is 1, not 0. * length: a positive integer… -
Re: Start Error: Couldn't determine the IIS Site associated with
Comment by gspotweb · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsOK, tried that on just the one IP address but got this: Could not start IIS. RedGate.Profiler.Engine.Exceptions.CannotStartSessionException at bJ.Launch() at RedGate.Profiler.Session.ProfilerSession.j() Caused by: Could not start IIS. RedGate.Profiler.Engine.Exceptions.CannotStartIisSessionException at bQ.PerformLaunch()… -
Where is the connection string for Monitor stored at?
Today I moved (via detach/attach) the RedGateMonitor from one SQL instance to another obviously that broke the product because the connection string is different now... looking in the website's "web.config" file, the connection string isn't set there..... Where is it that I can reflect the move I did? -
SQL Prompt 9.5.1.9434 fails to launch
Opening SSMS this morning I was prompted to update to 9.5.1. It installed as usual, no errors. but it bombs when launching SSMS now. I downloaded the installer to see if it would update the install but it simply says I have a newer version already installed. Thanks! From the ActivityLog.xml, the last entry is the failure… -
Re: User Instances / AttachDBFile
I create a string to hold the name of the database and the attach string property, and, even though I test to make sue the file exists, the register command still says it doesnt... Any ideas? Public Sub SourceDatabase(ByVal serverName As String, ByVal databaseName As String, ByVal userName As String, ByVal password As… -
Error Dialog When Using SSMS - Invalid name character in Workstation Id
I am getting an error dialog on an extremely frequent basis whenever I do any of the following in SSMS:* Saving Scripts * Executing Scripts * Change Tabs * Scrolling Object Explorer I have no idea where this issue is coming from, but I'm getting very close to a point where I may have to uninstall SQL Prompt so that I can… -
Email notifications are failing - but they are not
I have recent started using email alerts for deadlocks, long running processes etc for a database. They are being generated and I am getting email ok. However, I am now seeing the following notification in red at the top of the dashboard: "Email notifications are failing: Configure Notifications" I can see the following… -
Cannot install, as part of SQL Developer Suite
Hi all, Firstly let me apologise if this isn't the correct forum for this query, I couldn't see where to put it!. I'm trying to install SQl Developer Suite (https://www.red-gate.com/products/sql-d ... per-suite/) first and foremost so that I can upgrade SQL prompt which I already have from 5.1 to the latest version. I'm… -
I am getting an error when trying to open a 15GB dump file
Could not load crash dump, HRESULT: 0x80004005 Microsoft.Diagnostics.Runtime.ClrDiagnosticsException at Microsoft.Diagnostics.Runtime.DbgEngDataReader..ctor(String dumpFile) at Microsoft.Diagnostics.Runtime.DataTarget.LoadCrashDump(String fileName) at… -
Open in Excel Numbers to String
When I right-click in the grid and choose Open in Excel, numbers are no longer converted to numerics in Excel. Now they are left-justified strings with the little green triangle warning that numbers are strings. This just started happening. I'm not sure exactly when, but I updated SQL Prompt last Friday. I'm running…
>1716 results
