MSSQL Servers no longer SHOW ALL DB's :)

[sansond]

You guys are the best. This has been a thorn in my side with EM for a long time.

Thanks so much!

[mickpage]

I understand that if you allow the user name "Guest" to exist in your database, the table definitions and stored procedures in that database are visible to EVERYONE on that shared server.

[Brangwyn]

Only if the guest account is actually enabled though iirc. I'm interested to know which method you did use to hide them though, I know of a couple, and both from what I've been told are unsupported by microsoft and can run you the risk of not getting those PSS calls answered.

[mresell]

Originally Posted by Brangwyn

Mucked around with the sp_MSdbuseraccess SP?

Can you say security?

[server-68]

MSSQL3 is showing all the dabtabases and users again.
Why? There is any change in the policy?

[Silverbug]

It was probably just missed,might pay to submit a ticket to support

[newmem]

yikes! Can't get EM to work if that happens again. Any updates or news on this?

[soky]

I logged onto mssql3 and it only showed my db's and the standard default ones.