Posts
Sort by recent activity
Subquery issues in 3.5
I had a working query:SELECT sd.*
, ios.*
FROM dbo.ShipDetail sd
INNER JOIN dbo.OrderDetail od
ON od.OrderDetailID = sd.OrderDetailID
INNER JOIN dbo.ImportOrderS...
Superseded Bundle 5 artifact removal recommendations
I have SQL Bundle 5 (SB5) installed and it continues to appear in the "Add or Remove Programs" list from the Control Panel - this is expected.
The "new" Installer that shows up with SQL Compare 6 l...
Select (All) --> Copy --> Paste creates gobs of empty lines
If you select either all or a chunk of a spaced-out SP that contains whitespce inserted by the comparison engine, then copy-paste that base/snippet into SSMS, the whitespce comes with it.
Any way y...
Object cannot be cast from DBNull to other types
This occurs in Beta 6 and v5.
The DB concerned (is NOT my design!) uses object names that are reserved words, e.g., [Group], [User]. I can send you the entire DB create script (all objects) as it'...
Font Error bug is back
When I fire up SQL Compare or SQL Data Compare I get an exception that had cleared up before I installed SQL Prompt 3 build 868. SQL Dependency tracker throws a different message for the same erro...
UD Aliases Whacked and Auto-Insert options lost
Just installed "real" version over the final beta - patched version (Build 819) having uninstalled the beta as instructed by RG (config files were preserved in %USERPROFILE%\Local Settings\Applicat...
Install over Beta - which option?
Must I uninstall the Beta, Modify it, or Repair it, please?
If I must uninstall, did you add new tags to the EngineOptions.xml file for the final release? The patch build added some, so I'm guessi...
No CL for simple situation - Build 819
With my cursor at $CURSOR$ (for the purpose of this post), I type "AND org." then waited for the CL - SILENCE!!!USE NCF
SELECT org.*
FROM dbo.Organization org
WHERE org.[Timestamp] >...
Brief "Help" for the revised "Alias Assignment" options, plz
Could you post a few lines explaining the changes to the Aliases tab of the Options dialog, specifically the "Alias Assignment" section, please... Wouldn't want to pick the wrong one(s)
Or let u...
DBCACHE Files - should we expect any clean up?
I just took a look at the ..\Local Settings\Application Data\Red Gate\SQL Prompt 3\ folder to ensure preservation of my EngineOptions.xml file and noticed a growing number of DBCACHE files, around ...