MS SQL Server - Can you create databases that are hidden from SQL 2005 mgmt Studio

Author

Can you create databases that are hidden from SQL 2005 mgmt Studio

Pyush Kumar

2005-10-31, 3:23 am

Is there any way to create databases that are hidden from SQL 2005 management
studio? Alternatively, i noticed thata there is a system databases folder in
management studio. Can I create my own folders and put decide what dbs to
place in them

Thanks in advance

Jonathan Miller

2005-10-31, 3:23 am

Pyush,

As far as I know there is no way to create a hidden database in sql server
2005. The real question is why do you want to create a hidden database? If
security is the problem simply install a second instance of sql server and
use a different password. This way you can seperate your database from the
main server. Also, you may try setting your database to autoclose.

http://msdn.microsoft.com/library/d...ssesecurity.asp

"Pyush Kumar" wrote:

> Is there any way to create databases that are hidden from SQL 2005 management
> studio? Alternatively, i noticed thata there is a system databases folder in
> management studio. Can I create my own folders and put decide what dbs to
> place in them
>
> Thanks in advance
>

Michael Cheng [MSFT]

2005-10-31, 3:23 am

Hi,

Thanks for your post.

From your descriptions, I understood you have two questions about SQL
Server 2005 Management Studio.

1. How to create database that could not be viewed by SQL Server 2005
Management Studio
2. Whether it is possible to create folder like "System Databases" in SQL
Server 2005 Management Studio

If I have misunderstood your concern, please feel free to point it out.

For the first question, I am afraid we cannot create such databases. All
databases will be viewed by Administrator. But you could create a certain
user who do not have the permission to access that database.

For the second question, the answer is also no. You cannot create custom
folder like "System Databases" in SQL Server 2005 Management Studio.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Sponsored Links