Comments
Sort by recent activity
As you mentioned, everyone has his own style. The nearly thirty options we support make the tool highly customizable, but there is place for more. We will certainly consider your new option request and will try to include them in the next beta or the final release.
Many thanks,
Andras / comments
As you mentioned, everyone has his own style. The nearly thirty options we support make the tool highly customizable, but there is place for more. We will certainly consider your new option request...
This is indeed a bug, and it will be fixed in the next beta.
Thank you,
Andras / comments
This is indeed a bug, and it will be fixed in the next beta.
Thank you,
Andras
Antitorgo wrote:
Are we supposed to post them here or send you all an email or both or what?
You may do both. If you post it it might be worth starting a new topic. If you would like to send it in email please send it to Andras.Belokosztolszki at red-gate.com
Andras / comments
Antitorgo wrote:
Are we supposed to post them here or send you all an email or both or what?
You may do both. If you post it it might be worth starting a new topic. If you would like to send i...
Matthew.Wilkerson wrote:
It appears that this does not work with the Express version of Microsoft Management Studio. Is there a reason why?
The Express version of Microsoft Management Studio does not support add ins in any form (neither officially nor unofficially). This is a resriction by Microsoft, and we could not find a way around it that would satisfy the requirements for SQL Refactor.
Andras / comments
Matthew.Wilkerson wrote:
It appears that this does not work with the Express version of Microsoft Management Studio. Is there a reason why?
The Express version of Microsoft Management Studi...
Ahimoth wrote:
Since I installed SQL Compare 5.x, the comparison of one of my DB's is failing. However versions before 5.x work fine on this database. The error I get happens while creating a comparison project after hitting "Compare Now", it scripts the databases fine, but during the "Comparing" step it stops and says "unexpected char: 0xFFFF". I searched the entirety of syscomments for a binary value of 0xFF, but found nothing in both databases. Is there anyway to pinpoint the source of this error? If not how do I get around it?
Hi,
could you send me a screenshot of this error to Andras.Belokosztolszki at red-gate.com please? It would help me to identify which stage the error seems to occur. Also, does this error occur when you compare this database to any other database, or does this occur with a specific combinations of databases?
Regards,
Andras / comments
Ahimoth wrote:
Since I installed SQL Compare 5.x, the comparison of one of my DB's is failing. However versions before 5.x work fine on this database. The error I get happens while creating a co...
Johan Van Hoye wrote:
I'd like to be able to "tell" the comparison engine that a table exists both in source and in destination databases but has a different name.
This is to avoid objects showing up as "New" on the one side and "Obsolete" on the other side.
e.g. when t_customers has been renamed to t_customer I'd like to be able to match these two sql objects although they appear to have a different name.
In our current version of SQL Compare we do not support mapping objects with completely different names. We have introduced experimental support for owner mappings, so you could compare objects with different fully qualified names, but with matching object names (e.g. dbo.mytable with someuser.mytable). I have added your request to our list of features that we consider in our future development.
Regards,
Andras / comments
Johan Van Hoye wrote:
I'd like to be able to "tell" the comparison engine that a table exists both in source and in destination databases but has a different name.
This is to avoid objects showi...
sandu wrote:
Hi
Well to be honest I do not see any reason for that either. Our Permissions are generated automatically and we gave the maximum grants on each object according to its type, which was the reason the function got this permission.
I actually solved this by only granting select to this function, hoping that in the application no one will try to insert/update or delete from this function.
Sandu
As far as I'm aware one cannot insert data into (or update) a table returned by a user defined function directly. These functions do not allow DML triggers either. I did raise this as a bug to Microsoft, and for this you do deserve the T-Shirt [image] . If you send me your address and preferred size (Andras.Belokosztolszki at red-gate.com) I'll send one this week.
Regards,
Andras / comments
sandu wrote:
Hi
Well to be honest I do not see any reason for that either. Our Permissions are generated automatically and we gave the maximum grants on each object according to its type, which ...
sandu wrote:
Ok
thanks
Waiting to hear from you
Sandu
Dear Sandu,
You are absolutely right, and this is a bug. I'm looking into it now, but meantime I would like to offer you a Red Gate T-Shirt if you give me the reason for granting both insert and update privileges on a table returning function.
Regards,
Andras / comments
sandu wrote:
Ok
thanks
Waiting to hear from you
Sandu
Dear Sandu,
You are absolutely right, and this is a bug. I'm looking into it now, but meantime I would like to offer you a Red Gate T-Shir...
Philippe Béal wrote:
Hello,
I have exactly the same problem. Is this issue resolved?
Could you send me the result of the query in an email to Andras.Belokosztolszki at red-gate.com or in a private message?
Thanks
Andras / comments
Philippe Béal wrote:
Hello,
I have exactly the same problem. Is this issue resolved?
Could you send me the result of the query in an email to Andras.Belokosztolszki at red-gate.com or in a p...
Freda wrote:
Hi
Tried it with both versions - 5 and 5.1
Thanks
Could you tell me using profiler what query is being executed at the time of this error?
Regards,
Andras / comments
Freda wrote:
Hi
Tried it with both versions - 5 and 5.1
Thanks
Could you tell me using profiler what query is being executed at the time of this error?
Regards,
Andras