Activity overview
Latest activity by dcolbert
Visual Studio 2010 DBSCHEMA file comparison
I saw this post:http://www.red-gate.com/messageboard/viewtopic.php?p=43318#43318
...and was wondering if there are any specific plans to support comparisons using DBSCHEMA files.
Thanks in advance!...
Qualify Object Names stops responding
I'm using SQL Prompt to go through existing DB objects and clean them up. I'm using "Qualify Object Names" quite a lot, and when it works it saves me a LOT of time.
However, quite frequently it st...
One particular database frequently doesn't respond
I have weveral databases on a particular server. For some reason, SQL Prompt will frequently lose the ability to resolve the "main hub" database.
It will resolve that there is a table and even sho...
Thanks for the reply. Your suggestion will help, but I would definitely love it as a new feature! / comments
Thanks for the reply. Your suggestion will help, but I would definitely love it as a new feature!
For some reason it's not doing it anymore.
If I see it again, I'll post what I know.
Thanks Paul! / comments
For some reason it's not doing it anymore.
If I see it again, I'll post what I know.
Thanks Paul!
Complicated data generation question
Is it possible to generate four INT columns of data, where:Column2 + Column3 + Column4 <= Column1
We receive data from an outside source with those fields populated, but the final three added ...
Field erroneously showing up twice in the suggestion list
I have the following query:
SELECT [AvailableForPurchase].[KC_ID],
[title_id],
[DayOfYear],
[AFP]
FROM [Aggregation].[dbo].[AvailableForPurchase] WITH (NOLOCK)
When I use CTRL-[Space] to expose...
I figured it out (and saw the same solution in another post...)
I needed to refresh the cache to include the new tables that have been created since the last refresh. / comments
I figured it out (and saw the same solution in another post...)
I needed to refresh the cache to include the new tables that have been created since the last refresh.
Working within schemas
SQL-Prompt doesn't seem to work with schemas other than "dbo". Is there a setting I am missing? Is that supported? If not, are there plans for that?