Posts
Sort by recent activity
Filter tables that start with _ (underscore)
How do I filter tables that start with an _ (underscore)?
just using _ doesn't work, as it filters everything. I tried [_] (sql style escape) and _ (regex style escape), and they didn't work either...
Cross database insert breaks auto-complete
insert into [AnotherDB].dbo.summarytable
select * from SaleOrder so inner join SaleOrderDetail sod on ...
at this point SQLPrompt is unable to generate suggestions for the join condition, nor is it...
Join suggestion dropdown deselects itself
Odd annoyance-
If I arrow down too quickly after "ON ", I see the first suggestion for a join condition select, then quickly deselects itself. If I wait a 2 second count or so before hitting the ar...
Modify Insert Into template?
Is it possible to modify the Insert Into template?
currently when you use the Insert Into generator, you get this:
INSERT INTO dbo.Sitemap
( SitemapId ,
ParentId ,
ApplicationId
)
VALUES ( 0 , -- S...
Saved Source Control Source not displayed when opened
When opening a Saved SQL Data Compare project that has a Source Control source or destination, the saved Repository is not selected.
The given key was not present in the dictionary.
I'm attempting to link a backup of my live database, and ran into this error:
The given key was not present in the dictionary.
Stack Trace:
System.Collections.Generic.KeyNotFoundException: The give...
nightly "Monitoring" process?
I currently support a small operation that uses the "Develop on Live" process. Hopefully I can change their mind one day, but until then-
I currently have an automated nightly process that restores...
Database Diagrams
Is there any way to check in Database Diagrams?