Posts
Sort by recent activity
Slight Bug
Run this snippet in through 'Find Unused Variables and Parameters'BEGIN
DECLARE -- User Friendly Constants
@Inactive BIT = 0,
@Active BIT = 1,
@Exists BIT;
SET @Exists = ( SELECT Ac...
Commit All Dependencies - I'd like the checkbox unchecked
RG,
When we are checking in code - we need the 'Commit All Dependencies' checkbox to come up unchecked - is there a setting I can modify to make this happen now that we have migrated to 5.0?
TIA,...
Slight bug with the 'Find Unused Variables and Parameters'
In the code below, if you run 'Find Unused Variables and Parameters' it will errantly flag the declaration of @AuditTable as 'The variable declared here is used before it has a value assigned to it...
How to exclude permissions in SQL Compare 11?
Team,
I have a ton of objects which are being flagged as deltas simply because of the listings under
-- Permissions
GRANT CONTROL ON TYPE:: [dbo].[typAccountLockInfo] TO [SQLProdReadOnly]
GRANT VIE...
'The value assigned here is never used' - but it is
I have a SQL Pattern which SQL Prompt shreds a incorrect - here is an outline of the code. As you can see - the two variables are assigned, used and returned. Any idea why the SQL Prompt thinks the...
Just installed the new update - Attempt to modify a collecti
Team,
Just downloaded and installed the update - 3.7.4.425
Kinda dead in the water now - the commit changes tab shows - Attempt to modify a collection once it has been frozen
The spinning ball indi...
Version 3.6.6.178 is REALLY slow
Source Control prompted me to update to 3.6.6.178 - and ever since Source Control is dog slow.
I see a Tweet for 3.6.7 - but it doesn't get pulled down by the 'Check for Updates' link on the Source...
--Text was encrypted - but it is not!
Hey Red Gate,
I am comparing 3 servers together. Server B, in one compare against Server A, has all of my column default constraint values visible. However when I compare Server B to Server C , it ...
How do you upgrade to the 'Professional' edition of 7?
All,
I have SQl Compare 'Standard' with the yearly maintenance. Is there a path for me to upgrade to the 'Professional' version with yearly maintenance?
Thanks,
Doug 8)
Triggers won't sync in SQL Compare 6
Is there anything special I need to do to make the triggers sync up with your product? It appears they are evaluated in the way that they are applied, so if I have 2 databases with the triggers app...