Comments
Sort by recent activity
Hi @mrmagilla73 From my own testing it looks to be working as intended, do you have a version where you believe it works differently compared to the latest? Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center? / comments
Hi @mrmagilla73 From my own testing it looks to be working as intended, do you have a version where you believe it works differently compared to the latest?Kind regards
Dan Calver | Redgate Softwar...
Hi @mrmagilla73 could you please provide a screenshot of this occurring, could I also ask for your version of SSMS. Thanks, Dan / comments
Hi @mrmagilla73 could you please provide a screenshot of this occurring, could I also ask for your version of SSMS.Thanks,Dan
Hi Arno, Apologies! I understand what you mean now, I've been able to replicate the issue exactly. I'm now raising this with the development team as a bug with Prompt. Thanks, Dan / comments
Hi Arno,Apologies! I understand what you mean now, I've been able to replicate the issue exactly. I'm now raising this with the development team as a bug with Prompt.Thanks,Dan
Hi atolmeijer, The underlying is due to a parsing/syntax error and thus SQL Prompt is unable to format it. You can see this by using the built in SSMS check mark for checking parsing. An expression of non-boolean type specified in a context where a condition is expected, near 'ColumnA' - If it helps I found this stackoverflow post that's related to the error message - https://stackoverflow.com/questions/23928619/sql-server-an-expression-of-non-boolean-type-specified-in-a-context-where-a-co I hope this helps! Thanks, Dan / comments
Hi atolmeijer,The underlying is due to a parsing/syntax error and thus SQL Prompt is unable to format it.You can see this by using the built in SSMS check mark for checking parsing.An expression of...
Hi Torsten, I'm only getting one space when formatting the SQL using your script style and the default. Thanks, Dan / comments
Hi Torsten,I'm only getting one space when formatting the SQL using your script style and the default.Thanks,Dan
Hi Tortsten, Thank you for reporting this to us! This doesn't seem to be a bug as having a space before the datatype seems to be the typical way of styling this (e.g., the examples on Microsoft's docs page: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-partition-function-transact-sql?view=sql-server-ver15). However if you wish to remove the space then please submit a feature request on the UserVoice forum. I hope this has been helpful, Dan / comments
Hi Tortsten,Thank you for reporting this to us!This doesn't seem to be a bug as having a space before the datatype seems to be the typical way of styling this (e.g., the examples on Microsoft's doc...
Hi @dyard @... Are you using a SQL Source Control or SQL Change Automation project first of all? / comments
Hi @dyard @... Are you using a SQL Source Control or SQL Change Automation project first of all?
Hi, In this case, you will need to upgrade your version of LocalDB, you can check the current version using this link: https://knowledge.autodesk.com/support/advance-steel/troubleshooting/caas/sfdcarticles/sfdcarticles/How-to-check-the-version-of-your-database-in-Advance-Steel.html To upgrade, you can follow the steps here: https://stackoverflow.com/questions/26897152/how-do-i-upgrade-sql-server-localdb-to-a-newer-version / comments
Hi,In this case, you will need to upgrade your version of LocalDB, you can check the current version using this link: https://knowledge.autodesk.com/support/advance-steel/troubleshooting/caas/sfdca...
Hi @Michaelbe I'd advise looking at the article here: https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found / comments
Hi @Michaelbe I'd advise looking at the article here: https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found
Hi, This isn't a bug to reassure you and is often down to incorrect syntax in the files. The solution on this can depend on whether the issue is with WorkingBases or Transients files. To investigate this further, I would advise reaching out to support at: https://productsupport.red-gate.com/hc/en-us / comments
Hi,This isn't a bug to reassure you and is often down to incorrect syntax in the files. The solution on this can depend on whether the issue is with WorkingBases or Transients files.To investigate ...