Activity overview
Latest activity by MikeyC
5.1.6.35 Still Generates Thread Aborted Events
I upgraded to 5.1.6.35 and I am still seeing thread aborted errors in the event log:
Event Type: Error
Event Source: SQL Prompt 5
Event Category: None
Event ID: 0
Date: 6/24/2011
Time: 8:43:12 AM...
Still getting thread aborted error in Event Log with 5.1
Paul Stephenson wrote:
A number of bugs have been fixed, including:
Prevented misleading Thread was being aborted message from being added to log
It looks like there are still thread aborted...
RedGate.IPNService Event ID 32
I just upgrade to the released 5.1 (5.1.4.11) and I am now seeing this in the RedGate event viewer log:
Event Type: Error
Event Source: RedGate.IPNService
Event Category: None
Event ID: 32
Date: 4...
Want your reported bug fixed? Report it as a suggestion?
I have had a number of conversations with Red Gate about the lack of bugs getting fixed in new SQL Prompt versions. The last one amazed me, here is a portion of the reply from Paul Stephenson:
Hi ...
Temp Table and Suggestion
Given the following code:/*
SELECT
1 AS TestField
INTO #Temp1;
*/
SELECT
<cursor>
FROM #Temp1 L
When I hit CTRL-space to bring up suggestions the alias L is not listed as a choice. I u...
Large SQL Batches vs. SQL Prompt
I noticed that SQL Prompt 5 doesn't work with large batches, just like SQL Prompt 4. Are the options in the XML file the same for SQL Prompt 5 to expand the amount of code that it looks at as they ...
Suggestions Not Working
If you paste this code into an SSMS window:CREATE TABLE #FilingOrder
(
P_ID VARCHAR(18) NOT NULL,
C_ID NUMERIC(18,0) NOT NULL,
F_O NUMERIC(38,0) NULL
);
CREATE U...
Expanding * indents an extra level
It is nice to see that the * expansion error from version 4 was worked on, but it wasn't actually fixed. In version 4 the first column was indented correctly, and all the rest of the columns were i...
Suggestion Inserted Instead of Indenting
I am running version 4.0.4.21 and have found that in some case SQL Prompt will insert a suggestion instead of indenting when I hit TAB
SELECT
DT.bac<selection start>kup_set_id,
DT.first_...
Doesn't suggest until I have typed entire object name
I have found that in some case SQL Prompt 4 (v 4.0.4.21) doesn't give me a suggestion until I type the entire object name, which seems a little late.
* To replicate create an SP:
USE master;
go
CR...