SQL SERVER LINKED SERVER TO SQL SERVER

USE [master]
GO

/****** Object:  LinkedServer [LEVENT]    Script Date: 16.5.2019 14:00:30 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'LEVENT', @srvproduct=N'2', @provider=N'SQLNCLI', @datasrc=N'BMS_SEMIH', @location=N'LEVENT', @catalog=N'LEVENT'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LEVENT',@useself=N'False',@locallogin=NULL,@rmtuser=N'logouser',@rmtpassword='logouser'