Viewing 3 posts - 1 through 3 (of 3 total)
Very good script!
It works on Sql Server 2008 and 200R2 just replacing the line
--SET @TotalMEMORYinBytes = CONVERT(NVARCHAR(10),(select physical_memory_kb from sys.dm_os_sys_info))
With
CREATE TABLE #SASAMemory (TotalMEMORYinBytes NVARCHAR(10));
DECLARE @sqlToExecute AS NVARCHAR(300)
IF (@ProductVersion LIKE 'SQL...
February 3, 2016 at 8:37 am
Section "Remote Admin Connections" is not correct.
1. This option is not related to restriction on local administrator but on local connections
2. The recommended value is 0 (only local connections are...
February 2, 2016 at 4:13 am
"You can't modify or delete the sa login". That is not exact as you cannot delete it, but you can rename it. I usually do it and I consider it...
September 24, 2015 at 3:20 am
Viewing 3 posts - 1 through 3 (of 3 total)