Comments
Sort by recent activity
Hi Steve,
The requirement for SQL Prompt to be able to provide suggestions is that you need to be actively connected to the database server.
So, if you are working on a local database and not connected to internet, SQL Prompt will continue to work fine. However, if your database server is located in a remote server, then internet connection is essential.
I hope that helps.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
steveculshaw wrote:
The comment ... Note: Offline working is not supported in the new version. ... has me worried
Do you mean it won't work with a working internet connection ? - I work on my laptop with a local database, and I often don't have internet.
/ comments
Hi Steve,
The requirement for SQL Prompt to be able to provide suggestions is that you need to be actively connected to the database server.
So, if you are working on a local database and not conne...
Hello,
Thank you for taking the time to report the issue.
Towards the completion of the installation, the installer goes through some stages wherein it runs Visual Studio to get the install process completed. This causes the hang perception and it is something we intend to look into in the future (not for v4 release)
However, the error message that you received is bizarre and we will look into it.
Excuse us for the inconvenience caused and thanks again for the feedback:)
Regards,
Tanya
Project Manager
Red Gate Software Ltd
digiguru wrote:
I seem to have had an issue installing. It looks like I've had sql server express on my PC in the past, and currently have SQL Server Management Studio. An error message appears stating that express will now close (thansk but it wasn't open) and then the installer hangs, but eventually completes.
Still seems to work - just thought I'd let you know.
/ comments
Hello,
Thank you for taking the time to report the issue.
Towards the completion of the installation, the installer goes through some stages wherein it runs Visual Studio to get the install process...
Hello,
Totally understand the issue. We will review this for the final release and keep you posted with updates regarding this.
Thank you for your patience.
Regards,
Tanya
Project Manager
Red Gate Software Ltd
PDinCA wrote:
May I, politely but firmly, say that porting Aliases is equally, if not more, important than snippets. Many of us rest with the standard set that come as part of v3.9 so we essentially have no need of the executable you mention.
However, re-typing a list of 160 Aliases, and growing, is a completely unacceptable task to expect us to manually undertake for a product upgrade.
Please reconsider priorities towards porting Aliases, rather than snippets.
Respectfully,
Stephen
/ comments
Hello,
Totally understand the issue. We will review this for the final release and keep you posted with updates regarding this.
Thank you for your patience.
Regards,
Tanya
Project Manager
Red Gate ...
Hello,
Nope. SQL Prompt v4.0 installs in a separate directory and does not port any of your v3.x settings. However, we do have an executable that will be made available shortly for porting your snippets from v3.x to v4.0.
Hope that helps!
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
Nope. SQL Prompt v4.0 installs in a separate directory and does not port any of your v3.x settings. However, we do have an executable that will be made available shortly for porting your sni...
Hello,
I have emailed a patch that should fix the exception.
Apologies for any inconvenience caused.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
I have emailed a patch that should fix the exception.
Apologies for any inconvenience caused.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
Hello,
SQL Prompt has a NOLOCK enabled on our queries to the database which causes the caching to fail when there is any data movement in the database. However, it is unlikely to happen all the time unless the database you are trying to access is a heavy load database that is consistently being updated/changed.
Can you run the Profiler and try to execute the query manually to see if it works?
If the above attempt fails try to execute the query after removing the NOLOCK hint and that will help understand the issue.
I would also recommend to check if you have VIEW DEFINITION permissions enabled on the database/server you are trying to use SQL Prompt on.
I hope that helps.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
SQL Prompt has a NOLOCK enabled on our queries to the database which causes the caching to fail when there is any data movement in the database. However, it is unlikely to happen all the tim...
Hello,
Apologies for the delayed response.
We have identified a possible reason for this issue and have addressed it in SQL Prompt v4 which is currently under development.
An early access of this release should be available end of May. I will keep the forum posted with the release updates.
Thanks for your patience and for reporting the issue.
Regards,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
Apologies for the delayed response.
We have identified a possible reason for this issue and have addressed it in SQL Prompt v4 which is currently under development.
An early access of this r...
Hello,
An early access of v4.0 will be available during the last week of May [image]
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
An early access of v4.0 will be available during the last week of May
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
Hello,
Sorry to keep you waiting but we are planning to have an early access build of SQL Prompt v4.0 available for our users sometime around April/early May!
The new version has gone through some massive re-engineering works which basically translates to fixing the *quirkiness* issues reported by users in the past.
Some of the noted changes with the new version would be;
Improved performance
Improved support on SQL statements like for e.g., DBCC statements
Improved support within sub-queries and aliases
Support for multiple JOIN clauses
New format option that allows you to indent sub-clauses for SELECT, INSERT, UPDATE and DELETE statements
Right click context menu to ‘Format code’ and ‘create new snippets’
Sleek UI that supports sharing of snippets and format styles with peers/colleagues
I hope that helps and the team is working hard to get this out...so keep watching the forums for more updates soon!
Thank you very much for your patience, interest and support!
*quirkiness –Failing to list columns after the WHERE clause in some scenarios or failing to list suggestions when working on sub-queries and other such glitches experienced while trying to use SQL prompt.
Regards,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
Sorry to keep you waiting but we are planning to have an early access build of SQL Prompt v4.0 available for our users sometime around April/early May!
The new version has gone through some ...
Hello,
Due to the technical implications attached to fixing it this has been a known issue with SQL Prompt for sometime now .
However, the good news is we are addressing this issue in V4.0 which is scheduled to be released in Q2 2009.
So the fix is on its way and its not far...if that helps at all [image]
Sorry for the inconvenience caused and thank you for all your patience.
Regards,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
Due to the technical implications attached to fixing it this has been a known issue with SQL Prompt for sometime now .
However, the good news is we are addressing this issue in V4.0 which is...