USE [master]
      GO

      
 ----  Drop the server role if it already exists 
      IF  EXISTS (
          SELECT name
                FROM sys.server_principals
                WHERE name = N'myRole'
      )
      DROP SERVER ROLE [myRole]


      
 ----  Create the server role 
      CREATE SERVER ROLE [myRole]
          AUTHORIZATION [sa]
      GO