DECLARE @CurrentServer VarChar(200)
DECLARE @OldServer VarChar(200)
SELECT @CurrentServer = CONVERT(VarChar(100),SERVERPROPERTY('servername'))
SELECT @OldServer = srvname from sysservers
IF @OldServer <> @CurrentServer
BEGIN
    Print 'A change in Database Hostname was detected...'
    Execute sp_dropserver @OldServer
    Execute sp_addserver @CurrentServer,local
    Print 'Database Hostname was updated succeesfully...'
END
Else
Print 'No change in Database Hostname was detected...'

@echo off
echo.
echo ***************************************************************************
echo * Merge Fusion eFilm SQL Database Hostname Update Utility                 *
echo * This utility will update the eFilm Workstation 3.x SQL Express Database *
echo * Hostname value to match  the computername and fix any problems related  *
echo * to database connectivity caused by change in the computername(Hostname) *
echo * after the SQL Express Database is installed on the system               *
echo ***************************************************************************
echo.
pause
echo.
SQLCMD -S %computername%\SQLEXPRESSEFILM -i eFilmCorrectDB.sql
echo.
NET STOP "SQL Server (SQLEXPRESSEFILM)"
NET START "SQL Server (SQLEXPRESSEFILM)"
pause