JosiahSiegel

/*
LOG STORED PROCEDURE RUN TIMES AND ERROR MESSAGES

Example:
====================
-- Place at beginning of your stored procedure
DECLARE @Parameters VARCHAR(200) = NULL;
SET @Parameters = 'Account: ' + ISNULL(@Account,'') + ' UserID: ' + ISNULL(@UserID,'');
DECLARE @StartTime DATETIME = GETDATE();
EXEC Call_ssProcedureLog @ObjectID = @@PROCID, @StartDate = @StartTime, @AdditionalInfo = @Parameters;

mattantonelli

[user]
  email = [email protected]
  name = That Guy
[push]
  default = matching
[alias]
  tree = log --graph --decorate --pretty=oneline --abbrev-commit
[hub]
  protocol = https
[core]

JosiahSiegel

DECLARE @temp_error_log TABLE
(
 date datetime,
 process varchar(50) null,
 text varchar(MAX) null
)

INSERT INTO @temp_error_log
EXEC sp_readerrorlog 0, 1, 'Login'

JosiahSiegel

SELECT sp.name AS login_name
FROM sys.server_principals sp
JOIN sys.database_principals dp ON (sp.sid = dp.sid)
WHERE dp.name = 'Joe'

JosiahSiegel

DECLARE @temp_error_log TABLE
(
 date datetime,
 process varchar(50) null,
 text varchar(MAX) null
)

INSERT INTO @temp_error_log
EXEC sp_readerrorlog 0, 1--, 'Login failed' 

JosiahSiegel

USE [AdventureWorks]
GO
ALTER USER [Joe] WITH LOGIN = [Joe]
GO

JosiahSiegel

DECLARE @Table varchar(255) = 'TableName'
DECLARE @Test char(1) = 'N'
DECLARE @FillFactorOverride varchar(3) = NULL
-- SET @Test = 'Y' to only output computed fill factor values. No database modifications will occur.
-- Set @FillFactorOverride to value other than NULL to override computed fill factor value
-- Example: @FillFactorOverride = '90'
-- =================================
DECLARE @CursorTable varchar(255)
DECLARE @MyIndex varchar(255)
DECLARE @MyFillFactor varchar(3)

JosiahSiegel

-- http://lassesen.com/msdn/Optimizing_Fill_Factors_for_SQLServer.pdf
SELECT
  '[' + s.name + '].[' + t.name + ']' AS TableName,
  '[' + i.name + ']' AS IndexName,
  SUM(c.Max_length) AS [KeySize],
  CASE
    WHEN SUM(c.Max_length) <= 900 AND
      SUM(c.Max_length) > 848 THEN '97'
    WHEN SUM(c.Max_length) <= 848 AND
      SUM(c.Max_length) > 403 THEN '96'

JosiahSiegel

SELECT $displayName, $cn FROM ROOTDSE 
WHERE $objectClass='user' AND $objectCategory='Person' 
    AND $sAMAccountName='x0000000' --AND $cn='';

JosiahSiegel

-- server 'sysadmin'
SELECT   name as 'sysadmin',type_desc,is_disabled
FROM     master.sys.server_principals 
WHERE    IS_SRVROLEMEMBER ('sysadmin',name) = 1
ORDER BY name

-- database owner
select suser_sname(owner_sid) as 'owner'
from sys.databases
where name = DB_NAME()