AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
My feedback
-
4 votesAdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
1 vote
Upvotes: 1
Could you validate if the issue exists with the latest version of SSMS - 17.9.1 and post back?
Also, please validate with SSMS 18 Preview 5.thanks
DinakarAdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
5 votes
Upvotes: 51
<=-=Nov 11 2014 11:50AM=-=>I agree with Keith. I also manage multiple SQL Server instances. This is a persistent annoyance for nearly the last decade.
<=-=Jan 6 2015 1:21PM=-=>The bug is over 10 years old. The SSMS team keeps saying they can’t reproduce it. It feels like they never actually use their product.
Problem seems to occur more frequently when you store multiple remote servers. It’s probably very reproducible once you have 3 remote servers stored.
Microsoft did try to contact me directly and use LiveMeeting to my computer. If I recall right, Microsoft couldn’t get LiveMeeting to work and then they pretty much abandoned attempting to fix this and claimed they cant repro it. I was working with chandrag@microsoft.com .
<=-=Mar 7 2015 10:05AM=-=>This issue is so annoying. My SSMS 2014 remembered my DB’s password for maybe 2-3 weeks and it hasn’t remembered it since…
We made some improvements in this area for SSMS 18.
Could you see if you can repro the issue with the latest Preview 5?thanks,
DinakarAdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
4 votes
Upvotes: 6
Do you get any syntax error when creating Certificates or Keys?
Thanks,
DinakarAdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
2 votes
How did you install SSMS 17.9? Was it a full install on a clean machine (i.e. with no prior versins of SSMS 17.x) or it was an upgrade from some older versions of SSMS 17.x?
If you upgraded, did you use the “Full 17.9 package” or the “Upgrade package”?
Aside from that, could you try to uninstall and reinstall and let us know if that addresses the issue?
Please update your SSMS to 17.9.1 (the latest as of this post) and repro the scenario. If you are still seeing issues, please post back and we can review.
thanks,
Dinakar -
4 votes
The error you report indicates that we are unable to read the Vulnerability Assessment rule store which is embedded as a resource in one of the SqlServer module’s dlls.
Unfortunately, we have been unable to reproduce this error. Perhaps you can provide some more information on how to reproduce. Specifically:
1. What environment are you running on? Are there any special restrictions applied to your PowerShell environment?
2. Have you tried on other machines? Does it reproduce there too?
3. Are you running just the Invoke-SqlVulnerabilityAssessmentScan cmdlet or is something taking place before that? What happens when you just run the one command?
4. Any other information that you think may be pertinent to reproducing?
Thanks -
2 votes
If I close SSMS uncleanly with documents open, I get a dialog asking me if I want to recover or not. I can choose not to recover some or all of them. Are you saying this dialog takes too long to load, or is not being shown?
Also, I think you can turn off auto recover altogether in tools\options\AutoRecover
-
2 votes
so this is a bit lame but in SSMS 17.x you need to set this environment variable to the DNS suffix of blob storage for the cloud you want: AZUREBLOBDNSNAME
The default is blob.core.windows.net.
For US Government cloud I think you would set AZUREBLOBDNSNAME environment variable to "blob.core.usgovcloudapi.net"I think this is fixed in the SSMS 18 preview, can you try it there?
-
77 votes
this is the current list from the v18 NuGet
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Management.Dmf.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Management.SmoMetadataProvider.dll
Microsoft.SqlServer.Management.XEvent.dll
Microsoft.SqlServer.Management.XEventDbScoped.dll
Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
Microsoft.SqlServer.Management.XEventEnum.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SmoExtended.dll
Microsoft.SqlServer.SqlEnum.dll -
2 votes
Upvotes: 1
We are looking into this one.
AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
6 votes
Upvotes: 2
There's a devious way to change the server name in the connection dialog - switch to the Additional Connection Parameters tab and add "Data Source=servername,portnumber"
That may not unblock this entire scenario, though.AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
3 votes
-
2 votes
Upvotes: 15
Do you happen to know if visual studio 2013/2015 exhibit the same behavior?
AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
18 votes
this item could be combined with this one: https://feedback.azure.com/admin/v3/suggestions/33531871/activity
-
4 votes
maybe this item becomes combined with this one: https://feedback.azure.com/admin/v3/suggestions/33532654/activity
-
33 votes
Hi, thanx for the feedback.
As Ben points out, if you know which fields on the Database object you need, you can use Server.SetDefaultInitFields to make sure the collection is initialized with all those fields in the first query.Is there a particular scenario, using the latest SMO NuGet, where use of SetDefaultInitFields isn’t sufficient to speed up the query noticeably?
If you have an Intellitrace or XEvents trace I could use for reference it’d be a great help.we've made changes to the "bad query" in recent versions of SMO to improve the worst case time. Previous versions where joining on DMVs like db_hasaccess and such that really slowed things down. Do you see any improvement in recent SMO NuGet package versions?
-
0 votes
When you close a query window SSMS tries to ping the server to see if the connection has any open transactions. Depending on your connection string and the version of the .Net framework installed, the version of SQL connected to, etc, making that connection active after a long idle period can take some time.
-
2 votes
Do you mean some other settings than what are included in Tools/Options/Query Results/Sql Server/Results to Grid ?
-
19 votes
We’ll investigate for a future release.
I've moved it to the "SQL Server" forum, where this can discovered more easily by us (SSMS feature Team).
-
0 votes
Upvotes: 0
Thank you for the suggestion. Vulnerability Assessment can now be run using SSMS 17.4.
AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
Does this happen consistently or only the first initiation of SSMS?
Also, please share version info for SSMS/SSIS and what instances they are connecting to so we can figure this out.
thanks,
Dinakar