Activity overview
Latest activity by paulh
Compare not detecting ALLOW_SNAPSHOT_ISOLATION
I'm doing a full compare but SQL Compare is not detecting the ALLOW_SNAPSHOT_ISOLATION setting
Is it not supported or do I have to change other parameters?
Paul
WP7 Profiling
I notice that WP7 profiling is on the roadmap - any idea when this will make it into the EAP?
WP7 Profiling
Any plans for supporting profing on Windows Phone 7 - there's already one company that can do it :http://www.eqatec.com/Profiler/Home.aspx
License error
Upgraded to 1.1 and it's telling me that my license doesn't cover it as it's only for SQL Compare 8 etc.
This is a SQL Toolbelt license number starting with 507
Regards
Paul
Generator can't proceed
I have three table A, B and C with FKs A->B, A->C and B->C
Table C has a multi-column constraint across A, B and another column U.
When I try to generate 50K rows into C it stops saying that I've v...
Sorry, my fault...
I was editing the scripts to remove a large number of extended properties and changed from ntext to nvarchar(max), but I wrote it as [nvarchar(max)] rather than [nvarchar] (max) so the parser was confused.
Paul / comments
Sorry, my fault...
I was editing the scripts to remove a large number of extended properties and changed from ntext to nvarchar(max), but I wrote it as [nvarchar(max)] rather than [nvarchar] (max) ...
NVarchar(Max) odd results
When I compare a script folder with SQL Compare 7.1 it is showing the script version as containing
[sys].[nvarchar(max)]
whereas the live table is shown as
[nvarchar] (max) COLLATE Latin1_General_C...
Funnily enough I encountered the same issue this morning - I believe it's a permission issue..
Ensure that the user you are using to do the comparison has sufficient permissions, not sure if they need owner or if some subset is enough, but when running with our normal user, the comparison failed in the way you described.
Update: reading another topic there is a permissions FAQ for SQL Compare at http://www.red-gate.com/supportcenter/C ... 000072.htm / comments
Funnily enough I encountered the same issue this morning - I believe it's a permission issue..
Ensure that the user you are using to do the comparison has sufficient permissions, not sure if they n...
Ok, this is the same problem raised by cneyb - and the 'US English' idea suggested by Ben worked for me. / comments
Ok, this is the same problem raised by cneyb - and the 'US English' idea suggested by Ben worked for me.
Ok, just changed the tables to datetime, same thing happens - is this a config setting on my server? / comments
Ok, just changed the tables to datetime, same thing happens - is this a config setting on my server?