Comments
Sort by recent activity
Hi Emmanuel,
I'm afraid SQL Prompt 2 does not support the GRANT statement. We may add this functionality in version 3, depending on time.
Regards,
Tilman / comments
Hi Emmanuel,
I'm afraid SQL Prompt 2 does not support the GRANT statement. We may add this functionality in version 3, depending on time.
Regards,
Tilman
Hi,
Thanks for posting. Please see here for your answer: http://www.red-gate.com/messageboard/vi ... php?t=2476
Regards,
Tilman / comments
Hi,
Thanks for posting. Please see here for your answer:http://www.red-gate.com/messageboard/vi ... php?t=2476
Regards,
Tilman
Hi,
Thanks for posting. I'm afraid that isn't currently possible. Snippets can only insert static text. But it's an interesting suggestion. / comments
Hi,
Thanks for posting. I'm afraid that isn't currently possible. Snippets can only insert static text. But it's an interesting suggestion.
Ah, I see what the problem is. SQL Prompt 3 will support aliases, which will solve this problem.
Regards,
Tilman / comments
Ah, I see what the problem is. SQL Prompt 3 will support aliases, which will solve this problem.
Regards,
Tilman
Hi Janelle,
Thanks for posting. The reason why '.' inserts the selection is, because the dot is used to qualify table/column/etc. names, as e.g. in 'dbo.table.column'. If somebody wants to enter the above using SQL Prompt, they can select 'dbo' from the candidate list, press '.' to enter it and then the candidate list will open again immediately with all the objects that belong to 'dbo'. They can then select 'table', press '.'... And so on.
I'm not quite sure what your problem is, do you have identifiers that contain dots?
SQL Prompt 3 will allow much more configuration of the keyboard settings so hopefully that will solve your problem.
Regards,
Tilman / comments
Hi Janelle,
Thanks for posting. The reason why '.' inserts the selection is, because the dot is used to qualify table/column/etc. names, as e.g. in 'dbo.table.column'. If somebody wants to enter th...
Hi,
Thanks for posting. Please see this thread for the answer to your question: http://www.red-gate.com/messageboard/vi ... php?t=2476
Regards,
Tilman / comments
Hi,
Thanks for posting. Please see this thread for the answer to your question:http://www.red-gate.com/messageboard/vi ... php?t=2476
Regards,
Tilman
Hi Ken,
I'm afraid I still can't reproduce your problem. I created some 'Messages' output and copied it to the comment, but it didn't break SQL Prompt 2.
There's not a lot more i can do, I'm afraid. Hopefully, version 3 will fix your problem, as it will be a complete rewrite, including the parser.
Regards,
Tilman
PS: nick_70, could you report your problem in a separate thread, please, because it doesn't really fit in here. / comments
Hi Ken,
I'm afraid I still can't reproduce your problem. I created some 'Messages' output and copied it to the comment, but it didn't break SQL Prompt 2.
There's not a lot more i can do, I'm afraid...
Hi Ken,
I'm afraid I have no idea what could be causing your problem. Does this happen with every stored procedure? Does it also happen when you copy and paste the stored procedure to a new window? Do you think you could send me a copy of the sql where the problem happens? If you don't want to post it here, you can also pm it to me.
Regards,
Tilman / comments
Hi Ken,
I'm afraid I have no idea what could be causing your problem. Does this happen with every stored procedure? Does it also happen when you copy and paste the stored procedure to a new window?...
Hi Ken,
Thanks for posting. I'm afraid I couldn't reproduce your problem. Could you tell me a bit more about your system? I.e. what's your OS, Framework version, language/regional settings, SQL Server versions, machine specs? I take it you are only using Query Analyzer?
Regards,
Tilman / comments
Hi Ken,
Thanks for posting. I'm afraid I couldn't reproduce your problem. Could you tell me a bit more about your system? I.e. what's your OS, Framework version, language/regional settings, SQL Ser...
Hi,
Thanks for posting and sorrry for the problems your having. Could you tell me a bit more about your system? I.e. what's your OS, Framework version, language/regional settings, SQL Server versions, machine specs?
Regards,
Tilman / comments
Hi,
Thanks for posting and sorrry for the problems your having. Could you tell me a bit more about your system? I.e. what's your OS, Framework version, language/regional settings, SQL Server versio...