Posts
Sort by recent activity
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...
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...
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?