Comments
Sort by recent activity
Hi Bamajohn,
I know this is a workaround and not a solution, but it let you continue working in the short term. If you make a vertical selection (holding down alt and then dragging down across lines), you can modify every line at once, plus the suggestions window doesn't come up:
The selection: [image]
Single quote typed at end of list: [image]
Comma and single quote typed at start of list: [image]
First comma removed from list (after coming out of vertical selection): [image]
I'll have a chat with the rest of the team to see if we can get around your problem for good.
Best regards,
David / comments
Hi Bamajohn,
I know this is a workaround and not a solution, but it let you continue working in the short term. If you make a vertical selection (holding down alt and then dragging down across line...
Hi Markus,
So sorry for not replying to you sooner, we missed checking the Prompt 5 forums.
We've added support for SSMS 2014 into SQL Prompt 6. You can download this version from here.
Best regards,
David / comments
Hi Markus,
So sorry for not replying to you sooner, we missed checking the Prompt 5 forums.
We've added support for SSMS 2014 into SQL Prompt 6. You can download this version from here.
Best regard...
Hi Taylor,
We've just released a new version of SQL Prompt 6.3 with (hopefully) a fix to your issue. It now shouldn't crash SSMS or VS!
The update is available through the website or Check for Updates.
Please let us know if it doesn't work for you, or if you find any more issues.
Best regards,
David / comments
Hi Taylor,
We've just released a new version of SQL Prompt 6.3 with (hopefully) a fix to your issue. It now shouldn't crash SSMS or VS!
The update is available through the website or Check for Upda...
Hi Taylor,
Not a problem. I'll let you know once I've got some more detail on this, but this is definitely a priority for us.
David / comments
Hi Taylor,
Not a problem. I'll let you know once I've got some more detail on this, but this is definitely a priority for us.
David
Hi Taylor,
I have a workaround for the second script. I'm working through trying to get this fixed but it's taking some time.
If you put the begin transaction before the if statement, the script shouldn't crash SSMS any more:
BEGIN TRAN;
IF EXISTS(SELECT * from ... AND AssetID =
UPDATE ...
Not ideal I know, but I'll get there!
It seems to be a combination of the AssetID =, BEGIN TRAN; and UPDATE. When you remove one of these it works correctly again.
Thanks for your patience!
David / comments
Hi Taylor,
I have a workaround for the second script. I'm working through trying to get this fixed but it's taking some time.
If you put the begin transaction before the if statement, the script sh...
Hi Taylor,
I'm sorry you're getting crashes here!
Would it be possible to send over the script to my email address: david.priddle@red-gate.com ?
Does the crash happen as soon as you open the file? Or do you have to click around a few times or type before it crashes?
Best regards,
David / comments
Hi Taylor,
I'm sorry you're getting crashes here!
Would it be possible to send over the script to my email address: david.priddle@red-gate.com ?
Does the crash happen as soon as you open the file? ...
Thanks Taylor!
This was instantly reproducible on my end. We're looking into this now, and we'll let you know when we've gotten some more information.
Best regards,
David / comments
Thanks Taylor!
This was instantly reproducible on my end. We're looking into this now, and we'll let you know when we've gotten some more information.
Best regards,
David
Hi sgtmango333,
I'm one of the developers on SQL Prompt. I had a call with Larry a couple of weeks back and it looked like the problem was unlikely to us.
How are the objects coming up as invalid? Through "Find Invalid Objects" or in the query window? If they are being underlined in red in the query window, that is SSMS's behaviour.
If you see the collation issues again, please let us know!
Best regards,
David / comments
Hi sgtmango333,
I'm one of the developers on SQL Prompt. I had a call with Larry a couple of weeks back and it looked like the problem was unlikely to us.
How are the objects coming up as invalid? ...
Hi Larry,
Would it be OK to do it early tomorrow morning for you? Let me know when we can start and I'll send over a meeting invite.
Best regards,
David / comments
Hi Larry,
Would it be OK to do it early tomorrow morning for you? Let me know when we can start and I'll send over a meeting invite.
Best regards,
David
Hi Larry,
Would it be possible to have a remote session with you so we can see this issue in action?
Best regards,
David / comments
Hi Larry,
Would it be possible to have a remote session with you so we can see this issue in action?
Best regards,
David