Although the guest user remains in all of the user and system databases performing the same general functionality in the SQL Server 2000 and previous versions, at the same time you can revoke the access as mentioned in BOL http://msdn2.microsoft.com/en-US/library/ms177573.aspx
Read More...