set min and max memory identical value

Hello,

How can I modify the following script to set min and max memory identical :
DECLARE @MaxMem float
if @IfExecute=1 EXECUTE sp_executesql @SQLString ;

IF @@microsoftversion/0x1000000 IN (11,12,14)
      set @SQLString = N' Select @MaxMemOUT =physical_memory_kb/1048576.00+1 FROM sys.dm_os_sys_info WITH (NOLOCK) OPTION (RECOMPILE)  ;' ;  -- 4193848KB or ~3.99GB of RAM for ''ADM-SQL14-1'' as an example
else
      set @SQLString = N' Select @MaxMemOUT =physical_memory_kb/1048576/1024.00 FROM sys.dm_os_sys_info WITH (NOLOCK) OPTION (RECOMPILE)  ;' -- 4193848KB or ~3.99GB of RAM for ''ADM-SQL14-1'' as an example
Print @SQLString ;
SET @ParmDefinition = N'@MaxMemOUT float OUTPUT' ;

Thank you

Best regars
bibi92Asked:
Who is Participating?
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
This does not set anything but a variable, so just set another variable with the same value!?
0
 
bibi92Author Commented:
Thank you best regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.