Skip to content

Instantly share code, notes, and snippets.

// Create Base64 Object
var Base64={_keyStr:"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=",encode:function(e){var t="";var n,r,i,s,o,u,a;var f=0;e=Base64._utf8_encode(e);while(f<e.length){n=e.charCodeAt(f++);r=e.charCodeAt(f++);i=e.charCodeAt(f++);s=n>>2;o=(n&3)<<4|r>>4;u=(r&15)<<2|i>>6;a=i&63;if(isNaN(r)){u=a=64}else if(isNaN(i)){a=64}t=t+this._keyStr.charAt(s)+this._keyStr.charAt(o)+this._keyStr.charAt(u)+this._keyStr.charAt(a)}return t},decode:function(e){var t="";var n,r,i;var s,o,u,a;var f=0;e=e.replace(/[^A-Za-z0-9\+\/\=]/g,"");while(f<e.length){s=this._keyStr.indexOf(e.charAt(f++));o=this._keyStr.indexOf(e.charAt(f++));u=this._keyStr.indexOf(e.charAt(f++));a=this._keyStr.indexOf(e.charAt(f++));n=s<<2|o>>4;r=(o&15)<<4|u>>2;i=(u&3)<<6|a;t=t+String.fromCharCode(n);if(u!=64){t=t+String.fromCharCode(r)}if(a!=64){t=t+String.fromCharCode(i)}}t=Base64._utf8_decode(t);return t},_utf8_encode:function(e){e=e.replace(/\r\n/g,"\n");var t="";for(var n=0;n<e.length;n++){var r=e.charCodeAt(n);if(r
@enriquein
enriquein / SSMSToolsPackAuditTriggers.sql
Created April 8, 2011 20:54
Generates the sql script that creates the audit table and triggers for a given table. For use on SSMSToolsPack Custom Scripts.
/*** Create audit tables for |ObjectName| and its triggers ***/
/*
This script requires SSMSToolsPack to be installed. This should be copy and pasted into a new
CustomScript that is enabled for tables. Afterwards, you can right click a table in ObjectExplorer,
select SSMSTools -> Run Custom Scripts -> [Name you gave to the script], and it will generate
this script but with the proper object names replaced. Then run the script to generate the
SQL script for table and trigger creation. For best results, set SSMS to display results as text.
Also, in order for the script to work your table should have a primary key defined.