Comments
Sort by recent activity
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) ...
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?
Sorry, found it - couldn't see anything in the help about so assumed it wasn't there / comments
Sorry, found it - couldn't see anything in the help about so assumed it wasn't there
Problem with 3. is that my column is not a number, it's a string and what I want is something like
webload00001, webload00002 etc
Also, I can't allocate your Id generator to a string column. / comments
Problem with 3. is that my column is not a number, it's a string and what I want is something like
webload00001, webload00002 etc
Also, I can't allocate your Id generator to a string column.
Just a thought, but how about computing an MD5 hash of the rows on each server and then comparing that.
It's computationally more intensive but much less data will flow.
Basically Data Compare generates a function/sproc for each table to combine the data and generate the MD5 hash and then uses that rather than the raw table as the comparison bit - the rest remains the same.
Oh and I want a 0.0001p royalty for each row compared by this method [image] / comments
Just a thought, but how about computing an MD5 hash of the rows on each server and then comparing that.
It's computationally more intensive but much less data will flow.
Basically Data Compare gene...
Sorry my bad... I hadn't clicked on the left on explorer so I didn't see the Tables directory. / comments
Sorry my bad... I hadn't clicked on the left on explorer so I didn't see the Tables directory.
Brian
No problem, just glad we could resolve it in the end. / comments
Brian
No problem, just glad we could resolve it in the end.
Brian
Thanks for that - I unregistered the DevExpress controls from the GAC and it worked fine.
Paul / comments
Brian
Thanks for that - I unregistered the DevExpress controls from the GAC and it worked fine.
Paul