Comments
Sort by recent activity
I click Post Comment but it disappeared and not posted. ---- I am looking for tool and try different, SQL Prompt is one of them. We have used Poors Man formatter but it does not understand even more syntax . We are working with SQL 2022 and Azure so we need the tool to format T-SQL to use it in SSMS 19-20, VS 2022, Azure Data Studio. VSC will be good. / comments
I click Post Comment but it disappeared and not posted.----I am looking for tool and try different, SQL Prompt is one of them.We have used Poors Man formatter but it does not understand even more ...
Hi Victoria, please try in the online formatter provided by RG. What is the result? FYI: the link https://www.red-gate.com/products/sql-prompt/#format-sql / comments
Hi Victoria, please try in the online formatter provided by RG. What is the result?FYI: the link https://www.red-gate.com/products/sql-prompt/#format-sql
Jon_Kirkwood said:
Hi there, I understand that the error being displayed there is coming from SQL Server directly and isn't being generated by SQL Prompt The IS NOT DISTINCT syntax is new for SQL Server 2022 & Azure SQL instances and is anticipated to throw a syntax error if executed against older versions of SQL Server. I suspect our online SQL formatter is not using SQL Server 2022 and this is why the syntax error occurs. Are you using SQL Prompt as a tool deployed to SSMS, VS or ADS on your local device? If this is the error you are receiving in your environment, then I suspect you are running this against an invalid version of SQL Server to parse this code https://learn.microsoft.com/en-us/sql/t-sql/queries/is-distinct-from-transact-sql?view=sql-server-ver16 Are you receiving any other errors than 'Incorrect syntax near distinct' when formatting your code?
Hi Jon, I do not use SQL Prompt, I am trying different tools to select what is suitable for us. We have used Poors Man formatter but it does not understand even more syntax constructions. So I have tried your online formatter and wrote the request. We need a tool for formatting T-SQL in SSMS, VS, Azure Data Studio. And also in VSC will be good but it is not mandatory for now. We are using SQL 2022 on-premise and Azure. Regards. / comments
Jon_Kirkwood said:
Hi there, I understand that the error being displayed there is coming from SQL Server directly and isn't being generated by SQL PromptThe IS NOT DISTINCT syntax is new for ...
Check it here and let me know about results please: https://www.red-gate.com/products/sql-prompt/#format-sql / comments
Check it here and let me know about results please:https://www.red-gate.com/products/sql-prompt/#format-sql
I have checked >ping my-server 192.168.0.101 and run docker run --rm redgate/sqlcompare:14 /IAgreeToTheEULA /s1:192.168.0.101\\sql2019 /db1:database1 /u1:sa /p1:my-password /s2:192.168.0.101\\sql2019 /db2:database2 /u2:sa /p2:my-password Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) / comments
I have checked>ping my-server192.168.0.101and run docker run --rm redgate/sqlcompare:14 /IAgreeToTheEULA /s1:192.168.0.101\\sql2019 /db1:database1 /u1:sa /p1:my-password /s2:192.168.0.101\\sql2019...
Thanx Victoria, and waiting for the fixed versions / comments
Thanx Victoria, and waiting for the fixed versions
Hi Roseanna, thnax, could you please look at https://forum.red-gate.com/discussion/87291/docker-cannot-connect-to-sql-server#latest I have wrote about Docker problems / comments
Hi Roseanna, thnax, could you please look at https://forum.red-gate.com/discussion/87291/docker-cannot-connect-to-sql-server#latestI have wrote about Docker problems
David Pond wrote:
Are you using SQL Search v1.1.9? This version will not work in SSMS 2014. Sorry I thought maybe we had bumped the beta build versions to v1.9.
You need to install the SQL Search beta from here: http://documentation.red-gate.com/displ ... eta2update
You should probably join the beta mailing list too, so they let you know when it is released.
Thank you! now it works in SSMS 2012 and SSMS 2014. / comments
David Pond wrote:
Are you using SQL Search v1.1.9? This version will not work in SSMS 2014. Sorry I thought maybe we had bumped the beta build versions to v1.9.
You need to install the SQL Searc...
David Pond wrote:
If you installed SQL Search before installing SSMS 2014 you need to follow these instructions. http://documentation.red-gate.com/displ ... ent+Studio
Let me know if that doesn't work for you.
1. I have uninstalled SQL Search 1
2. I did not find the SSMS Integration Framework, only SSMS Integration Pack.
3. Installed SQL Search 1
The result is:
SQL Search appeared again in SSMS 2012
and it did not appear in SSMS 2014. / comments
David Pond wrote:
If you installed SQL Search before installing SSMS 2014 you need to follow these instructions.http://documentation.red-gate.com/displ ... ent+Studio
Let me know if that doesn't...
David Pond wrote:
If you installed SQL Search before installing SSMS 2014 you need to follow these instructions. http://documentation.red-gate.com/displ ... ent+Studio
Let me know if that doesn't work for you.
Thank you, I will check it.
I have SSMS 2008 and SSMS 2012 on my computer and SQLSearch works fine.
Then I have installed SSMS 2014 and after it I have downloaded and installed
the new SQL Search (without uninstall). It did not appear in SSMS 2014 but it still works in previous versions. / comments
David Pond wrote:
If you installed SQL Search before installing SSMS 2014 you need to follow these instructions.http://documentation.red-gate.com/displ ... ent+Studio
Let me know if that doesn't...