Name: | project |
Friendly Name: | English |
System: | |
Default Database: | metamedica |
Deny Windows Security Authenticated Connections: | |
Type: | SQL Server standard |
Permissions to Access the Server: |
Database | User | |
|
metamedica | project |
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