AdminMicrosoft SQL Server (Admin, Microsoft Azure)

My feedback

  1. 4 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      need-feedback  ·  4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

      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

      AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
    • 1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

        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
        Dinakar

        AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
      • 5 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          5 comments  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

          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…

          AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

          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,
          Dinakar

          AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
        • 4 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

            Do you get any syntax error when creating Certificates or Keys?

            Thanks,
            Dinakar

            AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
          • 2 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

              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?

              AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

              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
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                need-feedback  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                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
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  under review  ·  1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                  AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                  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
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    need-feedback  ·  1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                    AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                    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
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      planned  ·  4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

                      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
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                        AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                        We are looking into this one.

                        AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
                      • 6 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                          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
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            started  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          • 2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                              AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                              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
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                planned  ·  2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 
                              • 4 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  planned  ·  3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                  AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                                  maybe this item becomes combined with this one: https://feedback.azure.com/admin/v3/suggestions/33532654/activity

                                • 33 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                                    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.

                                    AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                                    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
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      under review  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                      AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                                      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
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        need-feedback  ·  3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                        AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                                        Do you mean some other settings than what are included in Tools/Options/Query Results/Sql Server/Results to Grid ?

                                      • 19 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

                                          I've moved it to the "SQL Server" forum, where this can discovered more easily by us (SSMS feature Team).

                                        • 0 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                            AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                                            Thank you for the suggestion. Vulnerability Assessment can now be run using SSMS 17.4.

                                            AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 

                                          Feedback and Knowledge Base