Comments
Sort by recent activity
Any updates on this? I'm having the same problem. Thx!
It looks like it's currently scheduled for SQL Compare 10, which I would probably expect some time next year. We're still in the process of another 9.x release, so v10 doesn't have a release date yet. / comments
Any updates on this? I'm having the same problem. Thx!
It looks like it's currently scheduled for SQL Compare 10, which I would probably expect some time next year. We're still in the process ...
Thanks for clarifying.
I've reproduced this and it seems to be a bug.
The issue is being looked at by the developers and is logged as SC-5144.
Sorry you've encountered this, but thanks for letting us know. / comments
Thanks for clarifying.
I've reproduced this and it seems to be a bug.
The issue is being looked at by the developers and is logged as SC-5144.
Sorry you've encountered this, but thanks for letting ...
Thanks for your post.
Column level permissions shouldn't cause any problems. Would you be able reply to the support ticket we've opened for you with the DDL for the problematic object?
Hopefully we can reproduce the problem and let you know what causing it. / comments
Thanks for your post.
Column level permissions shouldn't cause any problems. Would you be able reply to the support ticket we've opened for you with the DDL for the problematic object?
Hopefully we...
Hi Barry,
Sorry for the delay. I've looked into this and you're right.
Personally, I would have assumed it would show you the relationships between the users and the objects but it doesn't. I suppose the permissions aren't really dependencies as both objects can function without the other one. / comments
Hi Barry,
Sorry for the delay. I've looked into this and you're right.
Personally, I would have assumed it would show you the relationships between the users and the objects but it doesn't. I suppo...
Thanks for your post.
Users and Roles are displayed as objects, so you will be able to see their dependencies in the diagram.
Server level logins are not included in the diagram as we only show objects at the object level within the database. / comments
Thanks for your post.
Users and Roles are displayed as objects, so you will be able to see their dependencies in the diagram.
Server level logins are not included in the diagram as we only show obj...
Thanks for your post.
It looks like SQL Source control is having trouble polling your default trace. We use the default trace to figure out what metadata has changed, and what user made the changes (shared model).
Can you make sure you have the default trace enabled for that database and see if that helps?
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'default trace enabled', 1
RECONFIGURE / comments
Thanks for your post.
It looks like SQL Source control is having trouble polling your default trace. We use the default trace to figure out what metadata has changed, and what user made the changes...
Thanks for your help reproducing this.
I've experienced the same symptoms now, and it seems that when working with scripts, the compression state of the nonclustered indexes are ignored. Even though the setting is written to the file, it isn't considered in the comparison.
I've created bug SC-5113 for this. It also looks like this issue should be fixed in the next release of SQL Compare, but I haven't got an exact timeframe for that at the moment. / comments
Thanks for your help reproducing this.
I've experienced the same symptoms now, and it seems that when working with scripts, the compression state of the nonclustered indexes are ignored. Even thoug...
Thanks for your post.
Would you be able to send me a screenshot of this? As far as I know, when you set the compression on a clustered index, it sets the compression for the table. Since the table can only have one clustered index, it can only have one compression state.
I believe this is why we only compare the compression state of the table at the table level, and ignore the compression state of an index. / comments
Thanks for your post.
Would you be able to send me a screenshot of this? As far as I know, when you set the compression on a clustered index, it sets the compression for the table. Since the table ...
Thanks for your post.
It could be database triggers firing up causing this. If you have any triggers, could you try using the 'disable triggers' option? / comments
Thanks for your post.
It could be database triggers firing up causing this. If you have any triggers, could you try using the 'disable triggers' option?
Thanks for your post.
I haven't seen this error before. Are you able to connect to the repository using tortoise on the same machine?
Did you get the opportunity to submit an error report? If you can submit an error report (including your email address) then I should be able to look into this in more detail. / comments
Thanks for your post.
I haven't seen this error before. Are you able to connect to the repository using tortoise on the same machine?
Did you get the opportunity to submit an error report? If you c...