Comments
Sort by recent activity
Thanks for your feedback. This is a known issue and one that I don't think has an easy, simple solution. However, I've raised this as a feature request so that the developers will look into to see whether there's anyway of keeping the bookmarks after a code layout. For your reference the feature request tracking code is: SP-1580 / comments
Thanks for your feedback. This is a known issue and one that I don't think has an easy, simple solution. However, I've raised this as a feature request so that the developers will look into to see ...
The first thing to check would be to try to find out which other process has a lock on the options file. You could download Process Explorer from Microsoft - http://technet.microsoft.com/en-us/sysi ... 96653.aspx.
Once installed, run it and go 'Find' > 'Find handle or dll..', type in 'RedGateRefactorOptionSetDefaults' and then 'Search'. Does it show any processes with a handle on the file?
Regarding the EngineOptions.xml file; there's no reason why you can't copy the file over as long as you have the same versions installed on both your workstation and server. As always, I'd save a copy of the server options before you copy over the workstation options. / comments
The first thing to check would be to try to find out which other process has a lock on the options file. You could download Process Explorer from Microsoft - http://technet.microsoft.com/en-us/sysi...
Thanks for your feedback. I've added these to our feature request tracking database and they will be considered as future enhancements. / comments
Thanks for your feedback. I've added these to our feature request tracking database and they will be considered as future enhancements.
Could you explain exactly where you're writing your SQL code in Visual Studio 2008? If I click the 'New Query' button it opens a new Query window (with the Diagram, Results, SQL and Criteria panes). SQL Prompt isn't supported in this view so it shouldn't be enabled at all when coding. If you're writing your SQL in a .sql file then this is where SQL Prompt should be offering you the correct suggestions for the database that you've connected to. When you go to the SQL Prompt menu is 'Connect to Server..' highlighted? Could you try connecting to the server or if it is already connected try changing the connection to see if this makes any difference? / comments
Could you explain exactly where you're writing your SQL code in Visual Studio 2008? If I click the 'New Query' button it opens a new Query window (with the Diagram, Results, SQL and Criteria panes)...
Thanks for the feedback. Currently you'll have to clear the previous alert before you'll get an email notifying you of the next time the issue occurs. This was decided upon so that users aren't spammed if there is the same issue occurring frequently.
Obviously there are circumstances where it would be a lot better to have a more granular control over this frequency of emails. So I have raised this as a feature request and the developers will look into this when working on the next version. For your reference the feature request tracking code is: SSR-1377 / comments
Thanks for the feedback. Currently you'll have to clear the previous alert before you'll get an email notifying you of the next time the issue occurs. This was decided upon so that users aren't spa...
That's a tricky question as there isn't really a correct amount of spaces for a tab stop. It all depends on the editor that you're using and the platform that you're on. Generally the most common are 4, 5 and 8 (UNIX standard). / comments
That's a tricky question as there isn't really a correct amount of spaces for a tab stop. It all depends on the editor that you're using and the platform that you're on. Generally the most common a...
Unfortunately, it isn't possible to export scripts to an existing folder. This is by design and was set to prevent inconsistencies creeping in and causing issues when running the comparison. Apart from your method, presently the only work around is to run a comparison between the database and scripts folder and 'synch' to the folder.
We're considering adding the option to wipe the contents of an existing folder, if chosen, when exporting scripts. Would this be something that you'd be interested in seeing? / comments
Unfortunately, it isn't possible to export scripts to an existing folder. This is by design and was set to prevent inconsistencies creeping in and causing issues when running the comparison. Apart ...
Have you made sure that you've enabled system object prompting in the options? Go to SQL Prompt Options > Listed Candidates > Candidate Types and Filters, and check Show: System objects / comments
Have you made sure that you've enabled system object prompting in the options? Go to SQL Prompt Options > Listed Candidates > Candidate Types and Filters, and check Show: System objects
I think that the reason that SQL Prompt isn't offering you any suggestions is because you're writing your SQL code in a VB code file. SQL Prompt is only enabled, in Visual Studio, when working with a .sql file.
If you have large sections of sql that you need to integrate into your project could you create a sql file that you use to create your sql code snippets and then copy them into the VB file? / comments
I think that the reason that SQL Prompt isn't offering you any suggestions is because you're writing your SQL code in a VB code file. SQL Prompt is only enabled, in Visual Studio, when working with...
Thanks for reporting this. It is in fact a known bug that has previously been raised and added to our bug tracking database. It seems that unless you place a character before the $cursor$ at the beginning of a snippet, when the snippet is called the cursor will be placed at the end. If you aren't worried too much about the formatting difference you could add a space before the cursor as a workaround.
However, I have added your comments to the bug and for your reference the bug tracking code is: SP-732 / comments
Thanks for reporting this. It is in fact a known bug that has previously been raised and added to our bug tracking database. It seems that unless you place a character before the $cursor$ at the be...