TSQL-> Kullanıcı oluştur. Database Kullanıcılarını getir. Kritere uyarsa Sil.

USE master
-- Kullanıcı oluşturuyoruz.
CREATE LOGIN
 endpoint_owner
WITH
 PASSWORD='pwd'
GO

CREATE

CREATE PROCEDURE Dbo.usp_getcontext
As
SELECT SUSER_NAME() as 'LOGIN', USER_NAME() AS 'USER NAME'
go

USE master
-- Kullanıcı oluşturuyoruz.
CREATE LOGIN
 endpoint_owner
WITH
 PASSWORD='pwd'
GO

SELECT SYSTEM_USER as 'SYSTEM USER' , SUSER_NAME() as 'LOGIN', USER_NAME() AS 'USER NAME'

IF EXISTS( SELECT NAME FROM master.dbo.syslogins WHERE NAME='endpoint_owner' )
 DROP LOGIN endpoint_owner

SELECT NAME, LOGINNAME 
FROM master.dbo.syslogins 
WHERE NAME='endpoint_owner'

TSQL-> IF EXISTS DROP

IF EXISTS (SELECT * FROM [dbo].[sysobjects]
       WHERE ID = object_id(N'[schema].[procedure]') AND 
             OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [schema].[procedure]
GO
CREATE PROCEDURE [schema].[procedure] 
AS
BEGIN