Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: SQL Server System Audit Report

    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...

  • RE: SQL Server System Audit Report

    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...

  • RE: Stairway to SQL Server Security: Level 2, Authentication

    "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...

Viewing 3 posts - 1 through 3 (of 3 total)