Activity overview
Latest activity by Tobyh
Jonathan Watts wrote:
Okay, it looks like we have a regression, we are taking this problem very seriously as it is effecting so many of you and is having a very negative effect on the Beta. Hopefully, if we find a fix we can patch the beta.
If you can sent me a trace as described above I will see what I can do about debuging this problem. However, we haven't seen this during any of our testing, but there are a number of possible causes of this error, and without a trace we cannot tell where the problem is occuring.
Regards,
Jonathan
Were you able to replicate the problem with scheme I sent you ?
I my case it seems to be a problem with the store procedures.
Toby / comments
Jonathan Watts wrote:
Okay, it looks like we have a regression, we are taking this problem very seriously as it is effecting so many of you and is having a very negative effect on the Beta. Hop...
Jonathan Watts wrote:
Thanks. I or one of my colleagues will start looking into this shortly. rickybibi
This issue can occur in SQL Compare 5 too, usually due to permissions or full text index issues, so the first thing we need to establish is if this is a regression.
If you can run SQL Compare 5 against the same databases and tell me if you get the same error this would be very helpful.
Regardless of whether this occurs in SQL Compare 5 or both versions then the best way for us to find out what the problem is if you run a SQL Server profiler trace as the databases are registering. If you stop profiler after the error has occur and send us the trace we may be able to work out where SQL Compare is going wrong.
My email address is: jonathan [dot] watts [at] red [dash] gate [dot] com.
Kind regards,
Jonathan
I've sent a trace of both version 5 and 6. Currently we are not having any problems with version 5.
Toby / comments
Jonathan Watts wrote:
Thanks. I or one of my colleagues will start looking into this shortly.rickybibi
This issue can occur in SQL Compare 5 too, usually due to permissions or full text index...
Jonathan Watts wrote:
Tobyh,
Is this a regression, can you check whether it is happening with SQL Compare 5 too? Unforuntately there isn't any logging with SQL Compare as such. The best thing to is run a trace with SQL Profiler on the affected database, and send us the trace.
My email is jonathan [dot] watts [at] red [dash] gate [dot] com.
Thanks,
Jonathan
Works fine on SQL Compare 5 and I've sent you the trace / comments
Jonathan Watts wrote:
Tobyh,
Is this a regression, can you check whether it is happening with SQL Compare 5 too? Unforuntately there isn't any logging with SQL Compare as such. The best thing ...
Just being doing some more checking, and found it is just one of our databases.
Tried comparing 10 others and they compare fine so far.
It is just the one database, I can't find any logs created by your program. Is there away to turn logging on so I can give you more information ?
Toby / comments
Just being doing some more checking, and found it is just one of our databases.
Tried comparing 10 others and they compare fine so far.
It is just the one database, I can't find any logs created by...
When I compare any 2 databases it fails during the Registering Databases step on the [servername].[databasename]-Reading object text with the error "Object reference not set to an instance of an object".
Both servers are remote and are SQL 2005
I'm running Windows XP SP2 fully patched / comments
When I compare any 2 databases it fails during the Registering Databases step on the [servername].[databasename]-Reading object text with the error "Object reference not set to an instance of an ob...
we do not follow up external database links. In the final release we will try to do partial qualifiaction for mixed cases.
Partial would be great for first release.
Really enjoying this product so far ! / comments
we do not follow up external database links. In the final release we will try to do partial qualifiaction for mixed cases.
Partial would be great for first release.
Really enjoying this produc...
Excellent, can't wait.
Been doing the workaround.
In this beta we have not finished cursor support, but as a workaround would be to add a newline before the select keyword, and apply layout only to the select statement (the SQL Lay Out works on selections as well).
Thanks ! [image] / comments
Excellent, can't wait.
Been doing the workaround.
In this beta we have not finished cursor support, but as a workaround would be to add a newline before the select keyword, and apply layout only ...
Qualify Object Names
A) Qualify Object Names seems to have trouble when referencing a table in another database on the same server.
[Database].[dbo].[TableName]
But does still do the normal tables. If you have Temp tab...
Cursor Layout
When you layout CURSORs, I can't find any way to indent the SELECT statement.
/*Current*/
DECLARE Test CURSOR Fast_Forward FOR SELECT Col1,
Col2
...
Hi James thanks for the quick reply, and advice.
I've just been back in the product and add the new databases and now they are fine.
And have checked the location and have 11 files now.
I'm not sure what I did too cause the problem (I'm sure I'm not going mad, well I hope).
I've tried to do what I did this morning, which was create one project, then clone it and change the database 11 times.
I have not manage to duplicate what I happened this morning.
I'm sorry for posting this now, as I can't replicate the problem which doesn't help anyone.
Sorry again, next time I will try a fews times to be sure, I was too quick post.
Regards
Toby / comments
Hi James thanks for the quick reply, and advice.
I've just been back in the product and add the new databases and now they are fine.
And have checked the location and have 11 files now.
I'm not sur...