SQL Server

This is an old revision of the document!

SQL Server Security

Get Config Settings

SELECT *
FROM sys.configurations

Select Into Variable

USE master;
GO
 
DECLARE @TblTmp TABLE ([name] nvarchar(100), is_disabled bit)
 
INSERT INTO @TblTmp ([name], is_disabled)
SELECT [name], is_disabled
FROM sys.sql_logins
WHERE principal_id = 1
 
SELECT * FROM @TblTmp