Posts
Sort by recent activity
13.3.8.6436 : Copy and paste doesn't format
in recent days when i copy and paste from the code pane in SQL Compare into SSMS , what's pasted in the SSMS query window isn't formatted as it appears in SQL compare : it all pastes on one line. W...
13.3.8.6436 : Object reference not set to an instance of an object
having installed the frequent update from the blue bar which popped up today, I am no longer able to run a comparison (Even if i compare a database to itself) i get the error : : Object reference ...
How to stop SQL Search auto-searching
Is this a setting or somesuch that i am totally overlooking but does SQL Search have to start searching as soon as it opens.At times it decides to look across all databases for a blank string even ...
13.2.1.5640: Change in SQL view but no checkbox to allow deployment
SQL Compare (updated this morning) is showing a diffference between my proc on 2 database environments when i look in sql view pane, but it is not recognising the difference in the object list so s...
Duplicate objects found
It appears to be the case that if i change a table to a view or vice-versa then both objects of the same name end up in TFS and then redgate:sql source control cannot tell them apart.
To resolve i ...
Selecting individual dependencies for deployment
When the "deploy all dependencies (recommended)" page pops up, if i want to only select certain items in the list i need to cancel out and go and manually find those items in the full list to inclu...
Treating MIN and MAX as non-scalar
i'm getting a EI003 warning (Subquery may return more than one row.) for the following code where only one value would be returned; putting TOP 1 {} ORDER BY round it seems like overkill just to re...
Green squigglies with no helptext to explain why
loving the code analysis but on some procs i'm getting green squiggly lines but with no explanation when i hover over them - i can script an almost identical proc and not get them
SQLCompare won't recognise update to v13
SQL Compare constantly telling me there is an update, yet when I go to install it either tells me everything is up to date - or it goes through the install successfully and then still tells me ther...
Data Compare Export issue
Seems like an obvious one to ask but presumably the Rows to include checkboxes make a difference.
I have a table with over 235k rows and my comparision results come back with just 350 differences b...