Skip to content

Instantly share code, notes, and snippets.

@BartekR
BartekR / Application.Upgrade.cs
Created December 29, 2017 20:56
Microsoft.SqlServer.Dts.Runtime Application.Upgrade() original code from MSDN
// https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.upgrade.aspx
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace ConsoleApplication1
{
class Program
@BartekR
BartekR / TestColumnPrivileges.sql
Created January 15, 2017 17:51
SQL Server GRANT/DENY on column and table level
-- run separate steps, one number at a time
-- 01 create database
USE master;
GO
IF DB_ID('test_security') IS NULL
EXEC sys.sp_executesql N'CREATE DATABASE test_security;';
GO