@echo off
setlocal enabledelayedexpansion
set /p servername=Enter DB Servername :
set /p instancename= Enter Server Instance (optional): 
set /p portnumber=Enter Port Number : 
set /p dbname=Enter Database Name :
set /p username= Enter User Name :
set /p password= Enter Password :

echo ******PROCESSING %%G FILE******
set server= %servername%\%instancename%

if "%instancename%"=="" (
set server=%servername%
)

sqlcmd -U %username% -P %password% -S %servername%\%instancename%,%portnumber% -d %dbname% -i "%~dp0%droptables.sql" -o "droptables.log"

echo "check details into %~dp0%droptables.log"
EXIT /b

