Comments
Sort by recent activity
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...
Unfortunately, in it's current incarnation SQL Prompt doesn't support 2008 spacial data functions. However, the developers are working on SQL Prompt 4 as we speak and I've raised a feature request to support these methods and functions in this future version. This isn't due for release until Q2 2009.
For your reference the feature tracking code is: SP-1526 / comments
Unfortunately, in it's current incarnation SQL Prompt doesn't support 2008 spacial data functions. However, the developers are working on SQL Prompt 4 as we speak and I've raised a feature request ...
I'm sorry that you're experiencing these issues. Could you try entering the specific database name in the 'Connections to Ignore' options. So instead of choosing 'All databases' type in 'PWGDUM'. I know that this isn't going to resolve the issue if you have multiple databases on that particular server referenced. But I'd like to know whether explicitly stating the database name makes a difference. / comments
I'm sorry that you're experiencing these issues. Could you try entering the specific database name in the 'Connections to Ignore' options. So instead of choosing 'All databases' type in 'PWGDUM'. I...
Thank you for your feedback. This seems to be an issue that quite a few users hit as the synchronization scripts can grow to an unmanageable size. This is already logged as a feature request in our tracking software and it is something that I'm hoping that we are going to be able to implement in a future version of SQL Data Compare.
For your reference the feature tracking code is: SDC-771 / comments
Thank you for your feedback. This seems to be an issue that quite a few users hit as the synchronization scripts can grow to an unmanageable size. This is already logged as a feature request in our...
The code layout functionality allows you to layout your sql code and customize the way that it looks. This can help to make the code more readable or can be used to keep the layout of code consistent across a team. For details you can look at the help file which goes into more depth - http://www.red-gate.com/supportcenter/C ... c52128.htm / comments
The code layout functionality allows you to layout your sql code and customize the way that it looks. This can help to make the code more readable or can be used to keep the layout of code consiste...
Sorry that it's taken a while for someone to answer you. Could you try granting the user the VIEW SERVER STATE permission? Sometimes, if SQL Prompt needs to grab information regarding encryption keys this error can be returned if the user does not have this privilege. / comments
Sorry that it's taken a while for someone to answer you. Could you try granting the user the VIEW SERVER STATE permission? Sometimes, if SQL Prompt needs to grab information regarding encryption ke...
Unfortunately, there isn't a way to delay the speed that the tooltips appear. However, you can turn them off if they're interfering with the way you work. Go to 'SQL Prompt' > 'Options' > Behaviour > 'Information Panels', 'Enable object definition hints' and 'Enable parameter hints'.
I hope that helps. / comments
Unfortunately, there isn't a way to delay the speed that the tooltips appear. However, you can turn them off if they're interfering with the way you work. Go to 'SQL Prompt' > 'Options' > Behaviour...
Is there any more information presented in the exception window? Do you have the option to debug and see the stack trace? If not, is there any more information held in the Windows Event Viewer application logs? / comments
Is there any more information presented in the exception window? Do you have the option to debug and see the stack trace? If not, is there any more information held in the Windows Event Viewer appl...
Ok I apologise, I've tried it again and I do get the same outcome as you (I'm not sure why it wasn't working for me first of all. Probably a silly typing error!).
Once you've typed the variable manually, SQL Prompt does recognise it and give you the object hint information. So there is a part of SQL Prompt that does recognise it, after it's been typed.
The developers are working on SQL Prompt 4 at the moment and completely rewriting the parser. These inconsistencies are what they're concentrating on ironing out. So I've logged this as a bug in our bug tracking software and this will be tested against the SQL Prompt 4 build.
For your reference the bug tracking code is: SP-1482 / comments
Ok I apologise, I've tried it again and I do get the same outcome as you (I'm not sure why it wasn't working for me first of all. Probably a silly typing error!).
Once you've typed the variable man...