//Bld5


use master

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P@ssw0rd'


CREATE CERTIFICATE [Bld5]
With Subject = 'Bld 5'

BACKUP CERTIFICATE [Bld5] 
TO FILE = 'C:\Bld5\Bld5.crt'

select * from sys.endpoints


--DROP CERTIFICATE [Parker Street Public]
CREATE LOGIN Inspector WITH PASSWORD = 'P@ssword'
--DROP LOGIN Inspector


use [Inspection Team]

CREATE USER Inspector
-- DROP USER Inspector


CREATE CERTIFICATE [Parker Street Public]
AUTHORIZATION Inspector
FROM FILE = 'c:\Bld5\ParkerStreet.crt'





SELECT * FROM sys.endpoints
