Properties

Name: project 
Friendly Name: English 
System:  
Default Database: metamedica 
Deny Windows Security Authenticated Connections:  
Type: SQL Server standard 
Permissions to Access the Server:  

Users with this login

Database User
  metamedica  project 

SQL

if not exists (select * from master.dbo.syslogins where loginname = N'project')
BEGIN
    declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'metamedica', @loginlang = N'us_english'
    if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
        select @logindb = N'master'
    if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
        select @loginlang = @@language
    exec sp_addlogin N'project', null, @logindb, @loginlang
END
GO

See Also

Server overview
Logins list