Wednesday, March 21, 2012

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah
|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:

> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

No comments:

Post a Comment