Activity overview
Latest activity by steveculshaw
Alex B said:
Hi @steveculshaw, Also, just to let you know I've deleted the duplicate post of this! Kind regards, Alex
Thanks Alex / comments
Alex B said:
Hi @steveculshaw,Also, just to let you know I've deleted the duplicate post of this!Kind regards,Alex
Thanks Alex
Can SQL Compare work with a disconnected network?
Can SQL Compare work with a disconnected network?I'm looking at requirement for daily (nightly) synchronisation between two databases.The complication is there is no direct connection between them,...
Can SQL Data Compare work with a disconnected network?
Can SQL Data Compare work with a disconnected network?I'm looking at requirement for daily (nightly) synchronisation between two databases.The complication is there is no direct connection between ...
Thanks for the prompt response / comments
Thanks for the prompt response
DROP TABLE IF EXISTS dbo.MyTable flagged as invalid
I'm getting an error from SQL Prompt when I try and format my SQL, yet the SQL runs Ok ...
The error is from the statement ...DROP TABLE IF EXISTS dbo.MyTable
This is with SQL Prompt v7.2.0.260
Glad I found this post as I was getting very confused with multiple boxes appearing ... / comments
Glad I found this post as I was getting very confused with multiple boxes appearing ...
Thanks Andy, that works fine
andy.campbell.smith wrote:
You're right, it doesn't seem to like CTEs written like that at all. If you omit the column list and write it like
WITH [DAN_Decision_v4_data]
AS ( SELECT i.[ID] AS [ID] ,
i.[Decision_ID] AS [Decision_ID]
)
then it seems to format OK - would that work for you in this case? I'll log the inconsistent behaviour with column lists as a bug.
/ comments
Thanks Andy, that works fine
andy.campbell.smith wrote:
You're right, it doesn't seem to like CTEs written like that at all. If you omit the column list and write it like
WITH [DAN_Decision...
Formatting / wrapping text configuration not honoured
The formatting option for wrapping text doesn't seem to be working with CTE's ...
I've got one like so ...WITH [DAN_Decision_v4_data] ( [ID], [Decision_ID], [Clie...
Just downloaded and installed the patch ...
looking good :-)
Anu Deshpande wrote:
Hello All,
Many thanks for your patience regarding this issue.
I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.
Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248
Please let us know if this fixes your issue.
/ comments
Just downloaded and installed the patch ...
looking good :-)
Anu Deshpande wrote:
Hello All,
Many thanks for your patience regarding this issue.
I am pleased to inform you that we have fixed t...
Chris Auckland wrote:
Thanks for your post.
Unfortunately, the fix for this didn't make it into SQL Prompt 4. I believe the temporary workaround was to stop SQL Prompt laying out ALTER VIEW statements.
We are still working on the fix, and it is still open and scheduled for a future version. However, I'm not sure exactly when you can expect it.
For your reference the bug tracking number for this is SP-2770.
Is there any news on this bug and the same one in CREATE VIEW ?
And is there some way to see bug status ? / comments
Chris Auckland wrote:
Thanks for your post.
Unfortunately, the fix for this didn't make it into SQL Prompt 4. I believe the temporary workaround was to stop SQL Prompt laying out ALTER VIEW stat...