Activity overview
Latest activity by TomT
Window won't close: SQL Prompt 6.1.0.72
This is a bit maddening, the 'fetching script' window refuses to close, and clicking the X button does nothing. The window cannot be moved, and is blocking my view.
I have a screenshot, but don't s...
Temp Tables: suggestions not showing up
I thought this had been resolved, however when working with temp tables, I don't get column suggestions - table variables work fine however.
Version is latest: 4.0.3.10
That's great - thanks for your quick response to the problems. I appreciate Redgate's committment to solid products and great customer support. / comments
That's great - thanks for your quick response to the problems. I appreciate Redgate's committment to solid products and great customer support.
I'm hoping this and the other formatting issues will be fixed soon, it's quite frustrating..... / comments
I'm hoping this and the other formatting issues will be fixed soon, it's quite frustrating.....
Hopefully this will be fixed... / comments
Hopefully this will be fixed...
michaelfried wrote:
Tim,
I don't see that happening with SELECT * or INSERT INTO auto completion. Both types of auto-complete list all the columns in their natural table order.
I also don't see a setting to change that behavior either.
Mike
Try it using a temp or table variable - behaviour is different in ver. 4 than 3 - column order is NOT preserved..... This is unfortunate / comments
michaelfried wrote:
Tim,
I don't see that happening with SELECT * or INSERT INTO auto completion. Both types of auto-complete list all the columns in their natural table order.
I also don't see ...
SSMS 2008
I currently have SQL Prompt 3.9, and SQL Rfactor 1.3 installed in SSMS 2005. I'm thinking about upgrading SSMS to the 2008 version.
Will I have to re-install these two tools? I'm assuming they will...
Support for SQL Server 2008
What are the plans for supporting the next version of SQL Server, and what is the time frame?
Thanks
Thanks Bart, that did the trick.
Out of curiosity, why is this necessary? As I recall previous versions did this without this modification....
Also, is there anyway to speed up completion on remote servers? There's quite a hesitation in completing an entry once it's been chosen from the list of candidates....
Thanks / comments
Thanks Bart, that did the trick.
Out of curiosity, why is this necessary? As I recall previous versions did this without this modification....
Also, is there anyway to speed up completion on remote...
Hi Bart, thanks for the reply.
Here's an example:
DECLARE @test1 INT, @test2 VARCHAR(25)
SET @test1 = 12345
SET @test2 = CAST(@test1 AS VARCHAR(25))
When typing the cast statement, the suggestions when I type var, the suggestions are VAR and VARP...
This is different from how the previous version worked....
Thanks / comments
Hi Bart, thanks for the reply.
Here's an example:
DECLARE@test1 INT,@test2 VARCHAR(25)
SET @test1 = 12345
SET @test2 = CAST(@test1 AS VARCHAR(25))
When typing the cast statement, the suggestions wh...