Comments
Sort by recent activity
I may have skipped the last beta. From what I remember when I tried it I just added the path of the Compact db in the exclusion tab.
After I installed the release on a developer's desktop working with both Compact and Std, he complained he had to deactivate SQL Prompt. When I went to configure it the same what I had done with the beta, it seemed to me the server/db dialog was not what I had seen with the beta. There's been a couple of months between the 2 incidents, so I am not sure.
I tested the beta with SQL Compact (in november or december) and, at your suggestion, I added the exclusion path and it worked. When we installed the release we could not make it work anymore.
We've bought a bunch of serials but only a few of us work regularly with SQL Compact and that specific developer speaks a couple of languages but only 3 words of english [image] so he asked to post to the forum for him. Since he does lots of cross db queries between different versions, disabling SQL Prompt completely is not a good workaround for him.
thanks
Eric / comments
I may have skipped the last beta. From what I remember when I tried it I just added the path of the Compact db in the exclusion tab.
After I installed the release on a developer's desktop working w...
Thanks for replying so quickly.
A workaround I am using is to deactivate SQL Prompt when working in split view (I absolutely need split view sometimes). This brought a simple thought: the enable/disable could possibly be available in the toolbar which is easier to access than the menu (if you have access to adding your stuff in the toolbar of SSMS).
BTW, possibly because I haven't become familiar enough, I always prompt SQL Prompt manually with Ctr-space. The default Enter configuration was driving me mad because it was inserting stuff all the time when I was simply trying to format my code. Using Ctr-Space does not bother me but I am curious of the default behavior: what am I missing? How can we use Enter normally (I tried shift-enter and other variations but the auto-complete was always triggered)?
Thanks,
Eric / comments
Thanks for replying so quickly.
A workaround I am using is to deactivate SQL Prompt when working in split view (I absolutely need split view sometimes). This brought a simple thought: the enable/di...
Hi Bart,
Ignoring the db works. Good enough workaround. Thanks!
Eric
Happy New Year!!
[/img] / comments
Hi Bart,
Ignoring the db works. Good enough workaround. Thanks!
Eric
Happy New Year!!
[/img]
Swallowing would be a good first step but it will still freeze the UI at least 10 sec. each time. Would there be a way to flag a registered server so SQL Prompt ignores it?
Or, since those db are shown as [C:\...] in SSMS, a SQL Prompt option could be to ignore dbs with paths in their names. Quite crude, but efficient workaround if the elegant solution is expensive in time for the v3 release.
thanks,
Eric / comments
Swallowing would be a good first step but it will still freeze the UI at least 10 sec. each time. Would there be a way to flag a registered server so SQL Prompt ignores it?
Or, since those db are s...
I could, but it seems that applying several patches (VSTS SP1 among them) fixed the problem.
BTW, improvements are impressive! We had a buch of V1 licenses, then moved to the free but quite buggy V2 but did not participate in the V3 beta because of time constraints.
Can't wait to order a few :P
Never thought it would/could be improved that much...
Eric / comments
I could, but it seems that applying several patches (VSTS SP1 among them) fixed the problem.
BTW, improvements are impressive! We had a buch of V1 licenses, then moved to the free but quite buggy V...
Brian,
I do extract in those formats. What I was refering to is not exporting the view itself but only the content of the Dependencies Panel in the lower right.
that small panel gives a nice quick summary of what other objects may be impacted by a modification of the current (selected) object. In a database with thousands of objects, it is real useful for quick analysis and I have found myself wanting to print that list on a 2 minutes notice before going into a meeting...but no way to print or export it. Just a list of Uses and Used By.
Just being able to copy the tree to the clipboard (as text) would be ok.
Eric / comments
Brian,
I do extract in those formats. What I was refering to is not exporting the view itself but only the content of the Dependencies Panel in the lower right.
that small panel gives a nice quick ...
No 2005 only. Same server in fact. / comments
No 2005 only. Same server in fact.
Brian,
I think I have found the culprit. In reviewing the compare options I was surprise to see that Ignore Indexes was ON. The "Ignore" word is in the header and easy to miss and my eye just saw that Indexes was checked.
Anyway, that schema has some FK defined on unique indexes that are not necessarily PK. This is legal/valid and there are good design reasons for this (NULL are invalid in PK but not in unique keys & I dislike compound PK made of 4+ columns).
I unchecked that option and the synch script was ok...
Eric / comments
Brian,
I think I have found the culprit. In reviewing the compare options I was surprise to see that Ignore Indexes was ON. The "Ignore" word is in the header and easy to miss and my eye just saw t...
Brian,
If you look in the source script, you will find the following line:
ALTER TABLE [dbo].[cSaleAssign] ADD CONSTRAINT [PK_cSaleAssign] PRIMARY KEY NONCLUSTERED ([SaleAssignTK])
So the table DOES have a PK. Anyway, the update script is generated by SQL Compare by comparing the source DB with an empty database; so it can't see a FK on a non existent PK. / comments
Brian,
If you look in the source script, you will find the following line:
ALTER TABLE [dbo].[cSaleAssign] ADD CONSTRAINT [PK_cSaleAssign] PRIMARY KEY NONCLUSTERED ([SaleAssignTK])
So the table DO...
Yes, I can supply scripts. Is there a way to send them to you without posting them publicly on the forum? / comments
Yes, I can supply scripts. Is there a way to send them to you without posting them publicly on the forum?