Settings and activity
10 results found
-
1 vote
Keith Roe
shared this idea
·
-
12 votes
An error occurred while saving the comment Keith Roe
supported this idea
·
-
6 votes
An error occurred while saving the comment Keith Roe
commented
This would be extremely helpful. Right now I have to bounce back and forth from my select to the temp variable to get data types and field names. It can take a very long time to put all of this together. This would be a HUGE timesaver.
This is an excellent suggestion. Supprised it has not been implemented yet.
Keith Roe
supported this idea
·
-
28 votes
An error occurred while saving the comment Keith Roe
commented
Something along these same lines would be just remembering the connections you had open last time you used SSMS would be helpful. I have many different instances I use on a daily basis. Would not mind being prompted for each connection as it starts up. As it stands, currently only prompts for the last connection used.
Keith Roe
supported this idea
·
-
72 votesKeith Roe
supported this idea
·
-
100 votesKeith Roe
supported this idea
·
-
341 votesKeith Roe
supported this idea
·
-
71 votesKeith Roe
supported this idea
·
-
34 votesKeith Roe
supported this idea
·
-
33 votes
An error occurred while saving the comment Keith Roe
commented
I recently installed SQL Reports. The database and temp database were named weird on the old server. So, when I recreated the database and temp database, there was a name mismatch between the two. In order to resolve the issue, I had to script out all the mentions of the temp database in the report server database. There were close to 80 sprocs and views that had to be scripted out by double-clicking to go to the item and then right-clicking and scripting them to clipboard and then pasting them in notepad (because for some MSSMS kept crashing). I was then able to do a search and replace in the script and run it. A lot more work than I should have had to do!!
Keith Roe
supported this idea
·
I would agree with this. Along those same lines, I would like it to not scroll to the bottom of the file list after right-clicking and choosing "Open" from the context menu. When you do, it jumps down to the bottom of the list. You have to scroll all the way back to where you were. I had an issue I was looking at and it took forever to open all the scripts I was looking at over the past 6 months and spent more time looking for the files than resolving the issue that I was trying to correct. A couple of times I opened the same script twice.