How to rewrite the query to not use CONCAT function in SQL Server 2008 R2?

From SQL Server 2008 R2 version and below the "+" (plus sign) is an operator used in a string expression that concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression or into another column. You can concatenate strings in SQL Server just by using the + operator. So to avoid using CONCAT, your code can be rewritten as:

SELECT dbname = DB_NAME(), file_name = name, TotalMB = CONVERT(decimal(12,1),size/128.0), UsedMB = CONVERT(decimal(12,1),FILEPROPERTY(name,'SpaceUsed')/128.0), FreeMB = CONVERT(decimal(12,1),(size - FILEPROPERTY(name,'SpaceUsed'))/128.0), Command = 'USE MASTER; ALTER DATABASE ' + DB_NAME() + '; MODIFY FILE (name = ' + [name] + ', size = ' + convert(int,round(1.15 * FILEPROPERTY(name,'SpaceUsed')/128,-1)) + 'MB)' FROM sys.database_files WITH (NOLOCK) WHERE type_desc = 'ROWS' ORDER BY file_id;