RE: SQL Security in a hosted environment.

As this excellent article points out, in some (most) hosted environments you can see other peoples databases in Enterprise Manager, Query Analyser or even DTS. Sometimes you can see the table names and structure and stored procedure text. I believe this relates to databases having a guest account enabled.

However, at least one hoster I know of has solved this problem very nicely. If you get a trial account at http://europe.webmatrixhosting.net and register your database in Enterprise Manager, you only see your own database! Likewise in Query Analyser. DTS shows them all.

My question, and perhaps I should post this more generally, is: How do they do this? My main hosting partner doesn't know how its done and I can't figure it out.

Ideas anyone?