Bertoncini

dssssssssssssssssssssssssss

Bertoncini

/*For MS SQL Server 2012 and above*/
USE [master];

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE database_id  = db_id('MyDB')

EXEC(@kill);

Bertoncini

EXECUTE AS LOGIN='domain\user.name';

select * from sys.login_token
where type ='WINDOWS GROUP'
order by 2

REVERT;

Bertoncini

DECLARE @DBName VARCHAR(64) = 'PDV'

DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))

INSERT INTO @ErrorLog
EXEC master..sp_readerrorlog 0, 1, 'Recovery of database', @DBName

INSERT INTO @ErrorLog
EXEC master..sp_readerrorlog 0, 1, 'Recovery completed', @DBName

Bertoncini

-- Identify repl errors
USE [DISTRIBUTOR]
SELECT * FROM MSrepl_errors
ORDER BY time DESC

-- Identify the publisher database id
SELECT * FROM MSpublisher_databases

-- Identify the ID number and command id of the command causing the problem. 
-- This will typically show up in the Replication Monitor.

Bertoncini

* text eol=lf

# source code
*.php text
*.css text
*.sass text
*.scss text
*.less text
*.styl text
*.js text

Bertoncini

# Android
platforms/android/assets/www
platforms/android/bin/
platforms/android/gen/
platforms/android/res/xml/config.xml

# iOS
platforms/ios/build/
platforms/ios/CordovaLib/build/
platforms/ios/www

Bertoncini

CREATE PROCEDURE [dbo].[stpAtualiza_Indices]

AS

BEGIN

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

-- Sai da rotina quando a janela de manutenção é finalizada