DECLARE @VecLogonName NVARCHAR(50);
DECLARE @VecLogonPwd NVARCHAR(50);
DECLARE @SQL NVARCHAR(4000);

/******************************************/
/* SQL Server account Vector Issue Tracker account     */
SET @VecLogonName = N'censusapplication';

SET @VecLogonPwd = N'tLje2fns';
/******************************************/


/*      */ 
SET @SQL = 'CREATE LOGIN ' + @VecLogonName + ' WITH PASSWORD = ''' + @VecLogonPwd + ''' ';
EXECUTE(@SQL);

/*  If it exists... */
/*SET @SQL = 'ALTER LOGIN ' + @VecLogonName + ' WITH PASSWORD = ''' + @VecLogonPwd + ''' ';
EXECUTE(@SQL);
*/

/*  If deleting  */
/*DROP LOGIN @VecLogonName;   */

EXEC sys.sp_addsrvrolemember @VecLogonName, @rolename = N'sysadmin';


/*  Check if it supports Mixed security mode */
SELECT   CONVERT(CHAR(100), SERVERPROPERTY('Servername'))                 AS Server                    ,
         CONVERT(CHAR(100), SERVERPROPERTY('ProductVersion'))             AS ProductVersion            ,
         CONVERT(CHAR(100), SERVERPROPERTY('ProductLevel'))               AS ProductLevel              ,
         CONVERT(CHAR(100), SERVERPROPERTY('ResourceLastUpdateDateTime')) AS ResourceLastUpdateDateTime,
         CONVERT(CHAR(100), SERVERPROPERTY('ResourceVersion'))            AS ResourceVersion           ,
         CASE
                  WHEN SERVERPROPERTY('IsIntegratedSecurityOnly') = 1
                  THEN 'Integrated security'
                  WHEN SERVERPROPERTY('IsIntegratedSecurityOnly') = 0
                  THEN 'Not Integrated security'
         END AS IsIntegratedSecurityOnly;