Batch file to execute SQL Server Stored Procedure

@echo OFF
SET ServerName=.\EXPR
SET Loc=C:\DataUpload\AccessDB
SET Schema=MDM
ECHO DB Server is %ServerName%
ECHO Location is   %Loc%
ECHO Schema is   %Schema%
ECHO Parameter 1 is %1
PAUSE
sqlcmd -Q "EXEC  [MDM].[dbo].[MDMSync]   '%Loc%'" -S   %ServerName% -d  %Schema%
PAUSE

Parameterized Script

@echo OFF
ECHO DB Server is %1
ECHO Schema is  %2
ECHO Location is %3
PAUSE
sqlcmd -Q "EXEC  [MDM].[dbo].[MDMSync]   '%3'" -S   %1 -d  %2

Writing to Text file using Stored Procedure Sql Server Database

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE WriteToFile
    @File VARCHAR(2000)
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @OLE    int
    DECLARE @FileID int

    EXEC sp_OACreate 'Scripting.FileSystemObject',@OLE OUT
    EXEC sp_OAMethod @OLE, 'OpenTextFile' ,@FileID OUT, @File , 8 , 1
    EXEC sp_OAMethod @FileID , 'WriteLine', Null, 'Hello'
    EXEC sp_OADestroy @FileID
    EXEC sp_OADestroy @OLE
   
END
GO


--EXEC MDM.dbo.WriteToFile 'C:\DataUpload\AccessDB\hello.txt'



sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE
GO

sp_configure 'Ole Automation Procedures', 1 ;
GO
RECONFIGURE
GO

Creating Linked Server with a name other than its Server name

EXEC master.dbo.sp_addlinkedserver
    @server = N'DEV',
    @srvproduct=N'MSDASQL',
    @provider=N'SQLNCLI',
    @provstr=N'DRIVER={SQL Server};SERVER=Servername\InstanceName;UID=user1;PWD=rosebud567;',
    @catalog=N'database1'