Comments
Sort by recent activity
Hi @torsten.strauss ,
It's great that it is now working.
You are absolutely right. Some of our default queries need a review to increase their coverage of the formatting options (especially the ones modified/introduced in more recent versions of Prompt).
In the meantime, the easiest way might be to preview your own query instead of using the default when editing your style: [image]
Kind regards,
Frederico / comments
Hi @torsten.strauss ,
It's great that it is now working.
You are absolutely right. Some of our default queries need a review to increase their coverage of the formatting options (especially the one...
Hi @torsten.strauss ,
I may be completely misunderstanding, but wouldn't Expressions > Operators > Alignment > To first list item (instead of the default To statement) work in this case?
With the above example you would get: BEGIN TRY
-- Generate divide-by-zero error.
SELECT 1 / 0;
END TRY
BEGIN CATCH
IF @TRANCOUNT > 0
AND XACT_STATE() <> 0
BEGIN
ROLLBACK TRAN;
END;
THROW;
END CATCH;
If this isn't what you want, can you please format the above code as you would like to see it?
Thanks,
Frederico / comments
Hi @torsten.strauss ,
I may be completely misunderstanding, but wouldn't Expressions > Operators > Alignment > To first list item (instead of the default To statement) work in this case?
With the a...
Hi @torsten.strauss,
Thanks for letting us know about this.
I tried to replicate the issue and taking the Default style as the base with the following modifications:
Statements > Control Flow > Indent BEGIN END keywords
Expressions > Operators > Place on new Line (Never or If longer than wrap column)
We get: BEGIN TRY
-- Generate divide-by-zero error.
SELECT 1 / 0;
END TRY
BEGIN CATCH
IF @TRANCOUNT > 0 AND XACT_STATE() <> 0
BEGIN
ROLLBACK TRAN;
END;
THROW;
END CATCH;
Is this the behaviour you desire?
Kind regards,
Frederico / comments
Hi @torsten.strauss,
Thanks for letting us know about this.
I tried to replicate the issue and taking the Default style as the base with the following modifications:
Statements > Control Flow > Ind...
Hi @tlaqua,
Thanks for getting in touch with us. I'm afraid this is currently not possible in SQL Prompt.
Can you please add a request for this feature in our UserVoice forums?
Kind regards,
Frederico / comments
Hi @tlaqua,
Thanks for getting in touch with us. I'm afraid this is currently not possible in SQL Prompt.
Can you please add a request for this feature in our UserVoice forums?
Kind regards,
Frederico
Hi HenrikM,
I'm sorry to hear you are seeing crashes in SSMS. Unfortunately, we haven't been able to replicate this behaviour on our end.
To help us track this down, can you please:
Let us know which versions of SQL Server instances you connect to?
Tell us what other SSMS extensions besides SQL Prompt have you installed in your system?
Enable verbose logging and send us the log file to sqlpromptteam@red-gate.com so we can check whether Prompt is doing anything at the time of the crash? The steps to do so are explained in this page.
Kind regards,
Frederico / comments
Hi HenrikM,
I'm sorry to hear you are seeing crashes in SSMS. Unfortunately, we haven't been able to replicate this behaviour on our end.
To help us track this down, can you please:
Let us know whi...
Hi @henrik_ffc ,
Thank you for reporting this.
We've recreated the problem locally and have generated an internal bug ticket (reference: SP-6449).
Best regards,
Frederico / comments
Hi @henrik_ffc ,
Thank you for reporting this.
We've recreated the problem locally and have generated an internal bug ticket (reference: SP-6449).
Best regards,
Frederico
Hi @sdks,
Thank you for reporting this.
Can you please let us know which version of SQL Prompt you are using? We've been unable to replicate either of these behaviours in VS2015 using our latest SQL Prompt 8.0.5.1758.
Also, can you please detail the steps you take to get a query in the "object file"? The only scenario we've seen where this could occur is if your query window is disconnected from the server for any reason. In this case, the expand wildcards command is ignored and no tables appear in the suggestions box.
Best regards,
Frederico / comments
Hi @sdks,
Thank you for reporting this.
Can you please let us know which version of SQL Prompt you are using? We've been unable to replicate either of these behaviours in VS2015 using our latest S...
Hi @naumad,
Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6446) to track it.
Best regards,
Frederico / comments
Hi @naumad,
Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6446) to track it.
Best regards,
Frederico
Hi @naumad,
We've fixed this issue in our latest version of SQL Prompt 8.0.6.1890 (installer here).
You can find more information about this release in this forum post.
Kind regards,
Frederico / comments
Hi @naumad,
We've fixed this issue in our latest version of SQL Prompt 8.0.6.1890 (installer here).
You can find more information about this release in this forum post.
Kind regards,
Frederico
Hi @torsten.strauss,
We've fixed this issue in our latest version of SQL Prompt 8.0.6.1890 (installer here).
You can find more information about this release in this forum post.
Kind regards,
Frederico / comments
Hi @torsten.strauss,
We've fixed this issue in our latest version of SQL Prompt 8.0.6.1890 (installer here).
You can find more information about this release in this forum post.
Kind regards,
Frede...