MS-SQL: How can I Filter Database after connecting web hosting
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.
sql-server database asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
add a comment |
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.
sql-server database asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
add a comment |
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.
sql-server database asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
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.
sql-server database sql-server database asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
edited Nov 13 '18 at 13:08
c_atlantis
asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
asked Nov 13 '18 at 13:00
c_atlantisc_atlantis
275
275
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
When you connect, right-click Databases in Object explorer and from Filter select Filter settings:
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:
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
add a comment |
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.
ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
add a comment |
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;
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
When you connect, right-click Databases in Object explorer and from Filter select Filter settings:
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:
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
add a comment |
When you connect, right-click Databases in Object explorer and from Filter select Filter settings:
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:
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
add a comment |
When you connect, right-click Databases in Object explorer and from Filter select Filter settings:
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:
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
When you connect, right-click Databases in Object explorer and from Filter select Filter settings:
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:
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
answered Nov 13 '18 at 13:12
Andrey NikolovAndrey Nikolov
4,0133821
4,0133821
add a comment |
add a comment |
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.
ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
add a comment |
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.
ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
add a comment |
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.
ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
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.
ref: https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-management-studio-16-3-august-2016-release/
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
answered Nov 13 '18 at 13:14
Md. Tazbir Ur Rahman BhuiyanMd. Tazbir Ur Rahman Bhuiyan
1,3521424
1,3521424
add a comment |
add a comment |
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;
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
add a comment |
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;
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
add a comment |
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;
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
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;
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
answered Nov 13 '18 at 13:33
Bartosz XBartosz X
1,1171220
1,1171220
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
