how to isolate a single database on shared hosting with MS SQL Server Management Studio

p1tboqfb  于 2023-08-02  发布在  SQL Server
关注(0)|答案(1)|浏览(109)

this is not a code question but rather a connection question.

I have NetworkSolutions as a hosting provide.

I'm using SQL Server Management studio to access.

When I connect and click databases I literally see THOUSANDS... I want to isolate just MY database.

What additional connection parameters do I need to do that?

Thanks

jyztefdp

jyztefdp1#

I encountered the same with Plesk Admin shared hosting account where there are hundreds of databases. Listing all of them first to find the one you need can be time consuming. To fix this: -

  1. Log into SSMS
  2. BEFORE you expand the databases node, right click on Databases-->Filter-->Filter settings as illustrated

    .
  3. Enter your database name as illustrated

    . Then click OK
  4. At this point, click the (+) sign to expand the (FILTERED) Database node.

相关问题