It happens where ever you connect from. When I connect from my machine as an admin I see all the databases listed. But when I use the other login that...

No it does not give me any error. Would there be any command that could be barring all these logins from viewing the databases in the object explorer?

I am able to bring down the permissions to very low by using the following commands.

Deny All to Login_Name

Deny Alter Any Login to Login_Name

Grant Execute master.sys.xp_ReadErrorLog To Login_Name

This will help...

Go to this link. It has all you need.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

Thanks

Have you tried using

Exec master..xp_cmdshell 't1*.dtsx'