Comments
Sort by recent activity
Hello,
That is really bizarre!
There is no option in layout to insert spaces before or after dots and I am not able to reproduce this issue in our test environments.
Does it happen all the time or is it unpredictable?
Also, can you tell us if the issue happens only on particular editors? And do you have SQL Refactor installed in your machine?
Thanks,
Tanya / comments
Hello,
That is really bizarre!
There is no option in layout to insert spaces before or after dots and I am not able to reproduce this issue in our test environments.
Does it happen all the time or ...
Hi,
Just to ensure I understood it right, would you like to see all the fields aligned like this:
SELECT <columnname>
FROM <tablename>
ORDER BY <columnname>
If so , you can do this by going to SQL Prompt options - Layout - Tab size and wrapping - And set the 'number of spaces equivalent to a tab stop' to 3 or a value that suits you best.
Does that help?
Thanks,
Tanya / comments
Hi,
Just to ensure I understood it right, would you like to see all the fields aligned like this:
SELECT <columnname>
FROM <tablename>
ORDER BY <columnname>
If so , you can do this by go...
Hi Dave,
Ideally, you should be able to see the SQL Prompt menu in VS 2008 menubar without having to do anything different.
Can you check if the addin is checked in VS 2008 please? You can do this by going to Tools - Addin Manager - Check if SQL Prompt v3.8 is listed and is checked in 'Startup'
I hope that helps.
Thanks,
Tanya
P.S:When you say it appears to be working, do you actually see the SQL Prompt Candidate list with the suggestions in VS2008 wherein the SQL Prompt menu is not present in the editors toolbar or is it that the application works in general with the other editors, like Management Studio? / comments
Hi Dave,
Ideally, you should be able to see the SQL Prompt menu in VS 2008 menubar without having to do anything different.
Can you check if the addin is checked in VS 2008 please? You can do this ...
Hi,
Can you kindly let me know if you are using the latest v3.8 release version of SQL Prompt or the v3.8RC ?
And the exception from your log trace looks like some kind of connection failure and I would not worry provided SQL Prompt was behaving fine from the UI.
Thanks,
Tanya / comments
Hi,
Can you kindly let me know if you are using the latest v3.8 release version of SQL Prompt or the v3.8RC ?
And the exception from your log trace looks like some kind of connection failure and I ...
Hi Jon,
Thank you for bringing this issue to our notice.
When SQL Prompt writes any exception or errors into the log file, it ends up writing detailed logs that include user authentication details and we failed to hide the sensitive data for this particular scenario.
However, we have addressed this now in our code.
Thanks again and sincere apologies for having missed this bug!
Regards,
Tanya / comments
Hi Jon,
Thank you for bringing this issue to our notice.
When SQL Prompt writes any exception or errors into the log file, it ends up writing detailed logs that include user authentication details ...
Hi,
The difference is that Layout will now work in editors like VS, SSMSE and QA apart from MS Management Studio.
The layout options from SQL Prompt gives you 'lowercasing keywords' option that was a popular request from some of our SQL Refactor users.
Additionally, we fixed some hangs reported by SQL Refactor users in the layout functionality.
Thanks,
Tanya / comments
Hi,
The difference is that Layout will now work in editors like VS, SSMSE and QA apart from MS Management Studio.
The layout options from SQL Prompt gives you 'lowercasing keywords' option that was...
Hello,
I wouldn't call this as a replacement of SQL Refactor as SQL Refactor offers other functionalities like 'Smart Rename', 'Summarize Script', 'Encapsulate as new stored procedure', etc. that isn’t available in SQL Prompt. I would say the only common thing between SQL Refactor and SQL Prompt is the layout functionality as of now.
Thanks,
Tanya / comments
Hello,
I wouldn't call this as a replacement of SQL Refactor as SQL Refactor offers other functionalities like 'Smart Rename', 'Summarize Script', 'Encapsulate as new stored procedure', etc. that i...
Hi,
The difference between the Pro and the Standard edition is that the v3.8 Pro edition includes Layout functionality.
Thanks,
Tanya / comments
Hi,
The difference between the Pro and the Standard edition is that the v3.8 Pro edition includes Layout functionality.
Thanks,
Tanya
Hi Mike,
Please contact sales@red-gate.com to get this sorted.
Thanks,
Tanya / comments
Hi Mike,
Please contact sales@red-gate.com to get this sorted.
Thanks,
Tanya
Hi,
You can do that from the Options menu.
If you are on v3.6 then go to SQL Prompt menu-Options-'Pop up behavior' tab and click on the 'Schema Panel' on the left. Select 'Hide' and click ok to save your changes.
If you are on v3.8 then go to SQL Prompt menu-Options-'Behavior' tab and click on the 'Information Panels' on the left. Schema panel -select 'Hide' and click ok to save your changes.
And that would stop showing the schema panel (SQL script window) while you are using the Candidate list.
Thanks,
Tanya / comments
Hi,
You can do that from the Options menu.
If you are on v3.6 then go to SQL Prompt menu-Options-'Pop up behavior' tab and click on the 'Schema Panel' on the left. Select 'Hide' and click ok to sav...