Comments
Sort by recent activity
Thanks @Jon_Kirkwood. But I concur with @jsreynolds1, it works in 19.0.1, but not in 18.12.1. / comments
Thanks @Jon_Kirkwood. But I concur with @jsreynolds1, it works in 19.0.1, but not in 18.12.1.
akulprasad said:
SQL Promt options are not working for newly created objects. For example, if I create a new table, short cuts will work for that table only after closing and reopening SSMS. Is there any way to refresh metadata for newly created tables. Tried Ctrl+Shift+R ,but not refreshing SQLPromt IntelliSense Cache. Is there any way around for this issue
Have you tried "Refresh Suggestions" from the SQL Prompt menu, or Ctrl+Shift+D? [image] [image] [image] / comments
akulprasad said:
SQL Promt options are not working for newly created objects. For example, if I create a new table, short cuts will work for that table only after closing and reopening SSMS. ...
Not sure what the issue was, but it appears resolved. I was opening the SQL History from the command palette, and the window was blank. Today I tried enabling the Redgate toolbar and opening SQL History from the toolbar, and now it shows data regardless of where it's opened from. So I guess on the first opening, it has to be from the toolbar for some reason. Suggestion: If a user highlights a portion of a query and executes only that portion, it should be noted in SQL History. Currently, if I execute only a portion of the text in a query window by highlighting it, SQL History shows the complete query text with no indication that you didn't run it all. This could be very confusing. Having a way to see what was actually executed would be useful. / comments
Not sure what the issue was, but it appears resolved.I was opening the SQL History from the command palette, and the window was blank. Today I tried enabling the Redgate toolbar and opening SQL Hi...
Had this happen again after hiding the Redgate toolbar. So there is some intermittent issue with SQL History showing a blank screen when the Redgate toolbar is not active. (now on 10.13.1.31417) / comments
Had this happen again after hiding the Redgate toolbar. So there is some intermittent issue with SQL History showing a blank screen when the Redgate toolbar is not active. (now on 10.13.1.31417)
Like @Remko1981, I also run linked server queries like that at times. However, if I recall correctly, the last time I saw this message was when I had just connected to a server in the Object Explorer and was not running any query against it yet. In any case, I see you've published a presumed fix for this in 10.11.3. I've installed that version and will report back if I see the message again. Thank you. / comments
Like @Remko1981, I also run linked server queries like that at times. However, if I recall correctly, the last time I saw this message was when I had just connected to a server in the Object Explo...
I have linked servers, but none are SQL 2000. / comments
I have linked servers, but none are SQL 2000.
I am also getting this message. I've had it pop up twice now, both times when connecting to SQL 2019 servers. Everything works in SQL Prompt, but it's a distraction and annoyance to have to stop what I'm doing and dismiss a message that is not applicable to me at all. Please fix. I am using SQL Prompt 10.11.2.26629 and SSMS 18.10. [image] / comments
I am also getting this message. I've had it pop up twice now, both times when connecting to SQL 2019 servers. Everything works in SQL Prompt, but it's a distraction and annoyance to have to stop ...
That's a good question. I'd be curious to know the answer as well. It's painful to link our 15-20 DBs per server, but I can't imagine having to link hundreds. / comments
That's a good question. I'd be curious to know the answer as well. It's painful to link our 15-20 DBs per server, but I can't imagine having to link hundreds.
@Dan_J or anyone at Redgate - could we please get an update on this issue? It's been almost 8 months since reported and it continues to be an issue. / comments
@Dan_J or anyone at Redgate - could we please get an update on this issue? It's been almost 8 months since reported and it continues to be an issue.
Dan_J said:
Hi @DROP_TABLE_Students,
I just wanted to check if you have been able to check if you continue to see this issue in v.7.2.31 (https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.2.31.12796.exe)?
Hi @Dan_J Sorry this took so long to get to. I was not able to replicate the issue in 7.2.31. I was able to replicate the issue in 7.2.32. Hope this helps narrow down the root cause. / comments
Dan_J said:
Hi @DROP_TABLE_Students,
I just wanted to check if you have been able to check if you continue to see this issue in v.7.2.31 (https://download.red-gate.com/checkforupdates/SQLSo...