User Properties

Name: guest 

SQL

if not exists (select * from dbo.sysusers where name = N'guest' and uid < 16382 and hasdbaccess = 1)
    EXEC sp_grantdbaccess N'guest'
GO

See Also

List of users