Activity overview
Latest activity by KevinGreiner
I'm having the same problem. Windows 10 fully updated, running installer as admin doesn't help. / comments
I'm having the same problem. Windows 10 fully updated, running installer as admin doesn't help.
That worked. Thanks for your help. / comments
That worked. Thanks for your help.
Sounds good. Thanks for your quick response. / comments
Sounds good. Thanks for your quick response.
"Disable Code Suggestions" menu item: both state and action
The menu item that says "Disable Code Suggestions". OK, that makes sense. "I should select this menu item to disable code suggestions."
But wait. There is a checkmark in front of it. Huh? What does...
Restarting SSMS 2012 rebound the keys to their defaults. Which is good...
However, I prefer FormatSQL bound to Ctrl-KD, just like Visual Studio. I also remove the Ctrl-BL and Ctrl-KY bindings to teach my muscle memory to always use Ctrl-KD.
Unfortunately, SQL Prompt appears to wipe out this change, replacing my keys with its defaults. / comments
Restarting SSMS 2012 rebound the keys to their defaults. Which is good...
However, I prefer FormatSQL bound to Ctrl-KD, just like Visual Studio. I also remove the Ctrl-BL and Ctrl-KY bindings to te...
I noticed the same problem. Yes, it coincided with the install of SSMS 2016 CTP 2. All my SQL Prompt key shortcuts are gone. Is there an easy way to restore them? / comments
I noticed the same problem. Yes, it coincided with the install of SSMS 2016 CTP 2. All my SQL Prompt key shortcuts are gone. Is there an easy way to restore them?
Confirmed that the beta fixes this. / comments
Confirmed that the beta fixes this.
The "loading database" box is visible and I see it progressing through processing objects, columns, parameters, indexes, script information, etc. Timing it this morning shows about 20 seconds.
I most often notice this when adding new columns to a table which I then want to immediately use as part of a SELECT or INSERT. Although I have seen it happen when creating a new stored procedure, too. However, this is not consistent. I just attempted to recreate the problem on the same server and couldn't.
Yes, I think this is new in the past few months. Sorry, I can't narrow it much further than that.
This is not a trivial database but it's not huge, either. Here are the object counts.
81 CHECK constraints
2480 Default or DEFAULT constraints
439 FOREIGN KEY constraints
3 Inlined table-functions
1934 PRIMARY KEY or UNIQUE constraints
77 Scalar functions
1444 Stored procedures
67 System tables
13 Table functions
23 Triggers
2140 User tables
318 Views / comments
The "loading database" box is visible and I see it progressing through processing objects, columns, parameters, indexes, script information, etc. Timing it this morning shows about 20 seconds.
I mo...
I have been seeing the same behavior.
For me, I've noticed that it takes some time (10 minutes maybe?) for the suggestions to be updated. I run "refresh suggestions" on a large database over a VPN. It might take 30 seconds for the refresh to complete. But the list of suggestions isn't actually updated until later. Immediately running refresh again doesn't help. / comments
I have been seeing the same behavior.
For me, I've noticed that it takes some time (10 minutes maybe?) for the suggestions to be updated. I run "refresh suggestions" on a large database over a VPN....
I produced this code using 6.5.0.335.
Looking through my original post, I see that I missed two steps. First, execute just the first two statements. Then refresh your suggestions.
Now you should be able to reformat the UPDATE code shown and see the incorrect result. / comments
I produced this code using 6.5.0.335.
Looking through my original post, I see that I missed two steps. First, execute just the first two statements. Then refresh your suggestions.
Now you should be...