MS-SQL: How can I Filter Database after connecting web hosting










2















I bought a Windows Hosting. I am connecting the Database Server with my local Sql Server Management.



My problem is that: When I connect the Database with my username and password, I see to many database in the Database list. I have only one Database. Other databases belong to other custormers of my Hosting Company. I have to wait for all databases to load in the Object Explorer list. After loading complete, I can start to work on my database. Sometimes its getting a long time.



How can I set my local Sql Server as "load and show just my database from Hosting Server and ignore another databases info" The screenshot is below.



enter image description here










share|improve this question




























    2















    I bought a Windows Hosting. I am connecting the Database Server with my local Sql Server Management.



    My problem is that: When I connect the Database with my username and password, I see to many database in the Database list. I have only one Database. Other databases belong to other custormers of my Hosting Company. I have to wait for all databases to load in the Object Explorer list. After loading complete, I can start to work on my database. Sometimes its getting a long time.



    How can I set my local Sql Server as "load and show just my database from Hosting Server and ignore another databases info" The screenshot is below.



    enter image description here










    share|improve this question


























      2












      2








      2








      I bought a Windows Hosting. I am connecting the Database Server with my local Sql Server Management.



      My problem is that: When I connect the Database with my username and password, I see to many database in the Database list. I have only one Database. Other databases belong to other custormers of my Hosting Company. I have to wait for all databases to load in the Object Explorer list. After loading complete, I can start to work on my database. Sometimes its getting a long time.



      How can I set my local Sql Server as "load and show just my database from Hosting Server and ignore another databases info" The screenshot is below.



      enter image description here










      share|improve this question
















      I bought a Windows Hosting. I am connecting the Database Server with my local Sql Server Management.



      My problem is that: When I connect the Database with my username and password, I see to many database in the Database list. I have only one Database. Other databases belong to other custormers of my Hosting Company. I have to wait for all databases to load in the Object Explorer list. After loading complete, I can start to work on my database. Sometimes its getting a long time.



      How can I set my local Sql Server as "load and show just my database from Hosting Server and ignore another databases info" The screenshot is below.



      enter image description here







      sql-server database






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 13 '18 at 13:08







      c_atlantis

















      asked Nov 13 '18 at 13:00









      c_atlantisc_atlantis

      225




      225






















          3 Answers
          3






          active

          oldest

          votes


















          2














          When you connect, right-click Databases in Object explorer and from Filter select Filter settings:



          enter image description here



          In the dialog, enter "actif" in the row for database name and leave the default "contains" condition. Then when you expand the list of databases, you will see only your database. If there are other databases with "actif" in their name, change the condition to be "equals". Unfortunately, you can't persist this between restarts of SSMS, but you can select to which database to connect in the options of Connect dialog, which may reduce the need to use Object explorer:



          enter image description here






          share|improve this answer






























            0














            If you are using the latest management studio, you should be able to to that.



            See this:
            7. Support for filtering in the ‘Databases’ node of SSMS Object Explorer. Navigate to the ‘Databases’ node in Object explorer and click the filter icon in the Object explorer toolbar to filter the list of databases.



            enter image description here



            ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/






            share|improve this answer






























              0














              The problem you have here is that by default you are a member of [public] server role which by default have a privilege called VIEW ANY DATABASE.



              In your case all you need to do is to execute this query:



              DENY VIEW ANY DATABASE TO [Your_Login];


              As long as you are [dbo] on your database this will let you see only your database.



              You can find more info about it here;






              share|improve this answer






















                Your Answer






                StackExchange.ifUsing("editor", function ()
                StackExchange.using("externalEditor", function ()
                StackExchange.using("snippets", function ()
                StackExchange.snippets.init();
                );
                );
                , "code-snippets");

                StackExchange.ready(function()
                var channelOptions =
                tags: "".split(" "),
                id: "1"
                ;
                initTagRenderer("".split(" "), "".split(" "), channelOptions);

                StackExchange.using("externalEditor", function()
                // Have to fire editor after snippets, if snippets enabled
                if (StackExchange.settings.snippets.snippetsEnabled)
                StackExchange.using("snippets", function()
                createEditor();
                );

                else
                createEditor();

                );

                function createEditor()
                StackExchange.prepareEditor(
                heartbeatType: 'answer',
                autoActivateHeartbeat: false,
                convertImagesToLinks: true,
                noModals: true,
                showLowRepImageUploadWarning: true,
                reputationToPostImages: 10,
                bindNavPrevention: true,
                postfix: "",
                imageUploader:
                brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
                contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
                allowUrls: true
                ,
                onDemand: true,
                discardSelector: ".discard-answer"
                ,immediatelyShowMarkdownHelp:true
                );



                );













                draft saved

                draft discarded


















                StackExchange.ready(
                function ()
                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53281580%2fms-sql-how-can-i-filter-database-after-connecting-web-hosting%23new-answer', 'question_page');

                );

                Post as a guest















                Required, but never shown

























                3 Answers
                3






                active

                oldest

                votes








                3 Answers
                3






                active

                oldest

                votes









                active

                oldest

                votes






                active

                oldest

                votes









                2














                When you connect, right-click Databases in Object explorer and from Filter select Filter settings:



                enter image description here



                In the dialog, enter "actif" in the row for database name and leave the default "contains" condition. Then when you expand the list of databases, you will see only your database. If there are other databases with "actif" in their name, change the condition to be "equals". Unfortunately, you can't persist this between restarts of SSMS, but you can select to which database to connect in the options of Connect dialog, which may reduce the need to use Object explorer:



                enter image description here






                share|improve this answer



























                  2














                  When you connect, right-click Databases in Object explorer and from Filter select Filter settings:



                  enter image description here



                  In the dialog, enter "actif" in the row for database name and leave the default "contains" condition. Then when you expand the list of databases, you will see only your database. If there are other databases with "actif" in their name, change the condition to be "equals". Unfortunately, you can't persist this between restarts of SSMS, but you can select to which database to connect in the options of Connect dialog, which may reduce the need to use Object explorer:



                  enter image description here






                  share|improve this answer

























                    2












                    2








                    2







                    When you connect, right-click Databases in Object explorer and from Filter select Filter settings:



                    enter image description here



                    In the dialog, enter "actif" in the row for database name and leave the default "contains" condition. Then when you expand the list of databases, you will see only your database. If there are other databases with "actif" in their name, change the condition to be "equals". Unfortunately, you can't persist this between restarts of SSMS, but you can select to which database to connect in the options of Connect dialog, which may reduce the need to use Object explorer:



                    enter image description here






                    share|improve this answer













                    When you connect, right-click Databases in Object explorer and from Filter select Filter settings:



                    enter image description here



                    In the dialog, enter "actif" in the row for database name and leave the default "contains" condition. Then when you expand the list of databases, you will see only your database. If there are other databases with "actif" in their name, change the condition to be "equals". Unfortunately, you can't persist this between restarts of SSMS, but you can select to which database to connect in the options of Connect dialog, which may reduce the need to use Object explorer:



                    enter image description here







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Nov 13 '18 at 13:12









                    Andrey NikolovAndrey Nikolov

                    3,5831621




                    3,5831621























                        0














                        If you are using the latest management studio, you should be able to to that.



                        See this:
                        7. Support for filtering in the ‘Databases’ node of SSMS Object Explorer. Navigate to the ‘Databases’ node in Object explorer and click the filter icon in the Object explorer toolbar to filter the list of databases.



                        enter image description here



                        ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/






                        share|improve this answer



























                          0














                          If you are using the latest management studio, you should be able to to that.



                          See this:
                          7. Support for filtering in the ‘Databases’ node of SSMS Object Explorer. Navigate to the ‘Databases’ node in Object explorer and click the filter icon in the Object explorer toolbar to filter the list of databases.



                          enter image description here



                          ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/






                          share|improve this answer

























                            0












                            0








                            0







                            If you are using the latest management studio, you should be able to to that.



                            See this:
                            7. Support for filtering in the ‘Databases’ node of SSMS Object Explorer. Navigate to the ‘Databases’ node in Object explorer and click the filter icon in the Object explorer toolbar to filter the list of databases.



                            enter image description here



                            ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/






                            share|improve this answer













                            If you are using the latest management studio, you should be able to to that.



                            See this:
                            7. Support for filtering in the ‘Databases’ node of SSMS Object Explorer. Navigate to the ‘Databases’ node in Object explorer and click the filter icon in the Object explorer toolbar to filter the list of databases.



                            enter image description here



                            ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/







                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Nov 13 '18 at 13:14









                            Tazbir BhuiyanTazbir Bhuiyan

                            1,3341324




                            1,3341324





















                                0














                                The problem you have here is that by default you are a member of [public] server role which by default have a privilege called VIEW ANY DATABASE.



                                In your case all you need to do is to execute this query:



                                DENY VIEW ANY DATABASE TO [Your_Login];


                                As long as you are [dbo] on your database this will let you see only your database.



                                You can find more info about it here;






                                share|improve this answer



























                                  0














                                  The problem you have here is that by default you are a member of [public] server role which by default have a privilege called VIEW ANY DATABASE.



                                  In your case all you need to do is to execute this query:



                                  DENY VIEW ANY DATABASE TO [Your_Login];


                                  As long as you are [dbo] on your database this will let you see only your database.



                                  You can find more info about it here;






                                  share|improve this answer

























                                    0












                                    0








                                    0







                                    The problem you have here is that by default you are a member of [public] server role which by default have a privilege called VIEW ANY DATABASE.



                                    In your case all you need to do is to execute this query:



                                    DENY VIEW ANY DATABASE TO [Your_Login];


                                    As long as you are [dbo] on your database this will let you see only your database.



                                    You can find more info about it here;






                                    share|improve this answer













                                    The problem you have here is that by default you are a member of [public] server role which by default have a privilege called VIEW ANY DATABASE.



                                    In your case all you need to do is to execute this query:



                                    DENY VIEW ANY DATABASE TO [Your_Login];


                                    As long as you are [dbo] on your database this will let you see only your database.



                                    You can find more info about it here;







                                    share|improve this answer












                                    share|improve this answer



                                    share|improve this answer










                                    answered Nov 13 '18 at 13:33









                                    Bartosz XBartosz X

                                    1,0871020




                                    1,0871020



























                                        draft saved

                                        draft discarded
















































                                        Thanks for contributing an answer to Stack Overflow!


                                        • Please be sure to answer the question. Provide details and share your research!

                                        But avoid


                                        • Asking for help, clarification, or responding to other answers.

                                        • Making statements based on opinion; back them up with references or personal experience.

                                        To learn more, see our tips on writing great answers.




                                        draft saved


                                        draft discarded














                                        StackExchange.ready(
                                        function ()
                                        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53281580%2fms-sql-how-can-i-filter-database-after-connecting-web-hosting%23new-answer', 'question_page');

                                        );

                                        Post as a guest















                                        Required, but never shown





















































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown

































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown







                                        Popular posts from this blog

                                        Top Tejano songwriter Luis Silva dead of heart attack at 64

                                        政党

                                        天津地下鉄3号線