Comments
Sort by recent activity
Hi John,
How large is the database? If you're using a .docx or doc file then you might have trouble with large databases which we recommend using another format such as a. html or .chm file as outlined in the documentation page below. https://documentation.red-gate.com/sdoc5/generating-and-viewing-documentation/about-documentation-formats
Document (.docx and .doc)
We recommend generating a document (.docx or .doc) if you need to distribute an editable file, or if you wish to print the documentation.
The Portable Document Format (.pdf) file type is also suitable for printing. See Portable Document Format (.pdf).
Documents can be viewed in Microsoft Word and OpenOffice.org Writer.
Because of the large file size, we don't recommend this format if you're documenting large databases.
/ comments
Hi John,
How large is the database? If you're using a .docx or doc file then you might have trouble with large databases which we recommend using another format such as a. html or .chm file as out...
Hi John,
Sorry you're having trouble with SQL Doc. What version are you using? If you're using SQL Doc 4 or earlier, this is a 32-bit application so the GUI is limited by the size of the database. We've made SQL Doc 5 64-bit which should allow you to document larger databases.
If not already, can you please upgrade to the latest version and confirm if you have the same trouble?
If upgrading is not an option, I would suggest using the command line tool which is 64-bit. https://documentation.red-gate.com/sdoc5/using-the-command-line SQL Doc 5 Download Link: ftp://support.red-gate.com/patches/SQLDoc/03Jun2019/SQLDoc_5.0.2.1664.zip I hope this is helpful. Please let me know if there are any questions.
Kind regards,
Pete Ruiz
Redgate Support
/ comments
Hi John,
Sorry you're having trouble with SQL Doc. What version are you using? If you're using SQL Doc 4 or earlier, this is a 32-bit application so the GUI is limited by the size of the database....
Hi Mark, You can do this by setting the option to Place subsequent values on new lines to Never in SQL Prompt>Edit formatting styles>Expressions>IN and under Values. [image] I hope this helps. Please let me know if there are any further questions. Kind regards, Pete Ruiz Redgate Support / comments
Hi Mark, You can do this by setting the option to Place subsequent values on new lines to Never in SQL Prompt>Edit formatting styles>Expressions>IN and under Values.I hope this helps. Please let ...
Hello Torsten,
We have now released a fix for the formatting bug reference SP-7583 (release notes).
Can you please download the latest installer below and confirm that the issue is now resolved?
9.5.4.9799 Download
Cheers,
Pete Ruiz
Redgate Support
/ comments
Hello Torsten,
We have now released a fix for the formatting bug reference SP-7583 (release notes).
Can you please download the latest installer below and confirm that the issue is now resolved?
...
Hi Torsten,
Thanks for your patience on this one. We've finally gotten down to the root cause of the issue and have logged a bug which can now be referenced by SP-7583. We'll keep you updated on the progress of this bug.
Cheers,
Pete Ruiz
Redgate Support
/ comments
Hi Torsten,
Thanks for your patience on this one. We've finally gotten down to the root cause of the issue and have logged a bug which can now be referenced by SP-7583. We'll keep you updated on t...
Hello Torsten, Which error are you getting? Do you get an error when you try and format the query or after you try executing it? Can you share a screenshot of the error? Kind regards, Pete Ruiz / comments
Hello Torsten, Which error are you getting? Do you get an error when you try and format the query or after you try executing it? Can you share a screenshot of the error? Kind regards, Pete Ruiz
I believe because this is a batch separator and not a T-SQL statement
and should be on it's own line in the first place. This seems to be in
line with SSMS since executing this on the same line as a T-SQL
statement will produce a syntax error. I'm going to run this by our developers to see if there's anything we can do about this. Thanks for bringing this up. Pete Ruiz Redgate Support
/ comments
I believe because this is a batch separator and not a T-SQL statement
and should be on it's own line in the first place. This seems to be in
line with SSMS since executing this on the same line a...
Hello Jay, Thanks for reaching out and sorry
that you're having trouble with SQL Monitor. Have you already set up
your Email server settings in Configuration>Notification
settings>Email server settings? In order for SQL Monitor is able to
send outgoing mail, you need to set this up first. Please see the image
and documentation page below: [image] Documentation page: https://documentation.red-gate.com/sm9/configuring-sql-monitor/setting-up-email-notification If you've already set this up and you're still not getting the emails, can you please send over the log files so we can investigate further? / comments
Hello Jay, Thanks for reaching out and sorry
that you're having trouble with SQL Monitor. Have you already set up
your Email server settings in Configuration>Notification
settings>Email server s...
Hello Kevin, Sorry that you're having trouble
with SQL Clone. Can share a screenshot of the error you get when
deleting the image? Also, can you describe what you mean by removing the
SQL Clone Machine? Will you just be uninstalling SQL Clone or something
else? Kind regards, Pete Ruiz / comments
Hello Kevin, Sorry that you're having trouble
with SQL Clone. Can share a screenshot of the error you get when
deleting the image? Also, can you describe what you mean by removing the
SQL Clone ...
Hello Cory, Thanks for reaching out and sorry that you're having
trouble with SQL Monitor. Can you please send over the log files i'd
like to see if there's any clues in the logs for the long running query?
https://documentation.red-gate.com/sm8/advanced-operations/viewing-component-information-and-log-files Also, we don't quite support directly querying the data repository but I will ask my team for any suggestions. Kind regards, Pete Ruiz / comments
Hello Cory, Thanks for reaching out and sorry that you're having
trouble with SQL Monitor. Can you please send over the log files i'd
like to see if there's any clues in the logs for the long run...