DDL Log

This script creates DDL triggers to build a history of the creation, altering, or deletion of any of the objects on your database. You'll be able to query and report against that history table.

SCRIPT: DDL Log

PK4z>: SQLAdmin2008Reports/SQLAdmin2008Reports/DDLHistory2008.rdlUT
WN][uxY/ֿ'H 1Jb` 1yݍ#%UeMYˬ*&W<7UygOQ	jzo[4 uiUyo^JT~:SI׷{[ͫ8jNxt%;io	oD=,ϲ;W"[⾚>AGI#ۚԦ;|<4\lck	
m`28f
S>K=N
}7'9ςk'La$7||
L
e :}~{[5է$=rOj[7A˚1|=G+yҝ%sfHS7j{./pWZ}SosKt43:ܫ3_'mu6/땘qvSYl.v/ѹשzLzv\A>Gĸ>F4u2&F/UṗWӾ.(Ju_}(qzT⺳Kozw)sf-Tm1d|yL:#pC-ic-'kJ?ؠwbu>5~=V汫qY|$szu}x&;8pK'<٧Y3f7'qBL&طk01|-
@OtBɏo(D/ a^_+SGonRB
ZQL߻_oAPhy4f)	+SDT/f[t!7wzu_ݢ^֣6my3T.El{u]#R.ٿnyo`qt[Լd7ק_T]<I6M7/ws>?Ѽ=Ջ`ӽ	Yxf
+WS󨒛5?Z'|rv*QĻZ^<)wRd4ymҽĦMV~jdg |u|VPWY@*g?Zr~cro8_Y_l]z}ELʘC*P;J|ӡK[k[kۧXwwϷwx^݀oV`cOX̿Y^e$?y^/Te4yNreX^?2,cX\":Y6	zO+^v`׿]Gvog׿t[l@ח[2ÎE/сs{I-ayC.PD]QF_/'-ϕI722n_?'
w$Oϴ+vv{:m~.KF.݃`9yPj@\w`o4`rثo3xCQ/ǖ{v].M`>E)$0Ë5n{Y3OŽ|ꫵ|="w_vO{ߢ_0&vux7z{^~{x17doPkts@I(+g:7dOp}]_
h9?	-~ӊ|/_2`38RsVo;V}Q|@ڟPΏyU[֋?Wß91-׾_v,r0_6ofo㻘w>-wsCLrK"T/z8m>wC}{~9܇m?ˌT"pE&ǥcx ho.W]RRq4Aug=$mnެ
/xcI5A^[1񤣂Ɖ7|*7w?Tw~V~>g0%s3<?Ϗ`$0o-ʅŔ[}עu>
&r6_E!
NoO~kOCEZ䷫ګ⢹)x^N_xqաGx'K :pfNd׽/ݞ4` >VBқKG7ԽBI_?=0|:HzUcX?6A໎vIγ_1y?I}oO^X{ǯx:.M1U@N~~{?ؿ}+_/Y|xFQrSD[/
\5mB׻ܮGp|;0pްd;Y&˟ƩDqV?Im$<IMҘTOL,=ޤfXK|>_b>kn&@1muBsI4sحHM{̻[|Hxk`'oEc1>q:@Eo7&q)4w~NMK5}í_{&VL&طkjAGe^E"fկiƳ
9/{?3(>`DvwW^ؒ^XPzVϗoJ/gRXMW9/η>\/dA^.6#FOMiz*cAWUBOTP\8~"pz*(|3zt熫g*$1k×oyQrXn3w-םީw+K^
v`׿]Gvogqᄡ26_y˭uaO"͗@?IoCj?(/rn8o.TD]QF_/'-ϕI722_?%Dv|[}o+
G.t\XO\<υ.t\w|3]h7-2X3?/e@ן]puyg/G{
zCD{1\"/ʗPooW>ou VȾ(>xǼK|ñs8z犹ԕxN(,e73ˎ:ˆͬz|[g>7c1Y{gՉ^xzAMݟyW|_OډWahM7Cp%3)018`{/}3;DD?Fr?q-pfO-?,`6?l
)`_eW
h;Mj/޺g_,iE>qP9=}D
R7^q}r|s/E4LK'nyR~ϴ׃*6kHCM*8Þ?z8EA<vwlnI^y\3ׇ[3{s	^a%|A0^7
3MT7C͊g'>~f\Ɓχ_ԟL'5gћ{vM|*ûko?+낟gmq^Ÿw.n\4QSj{S_PGHUqʨN}O}ʺ7ۿoߟ0S7"a2F޸|/B)r&y~e~p}n={CTwcuӠG*loXo׼:ozq:߯̌7@3+s;=MV~4x';?#/~Ӊ[`97ys|Ywo8յ>d|e}=ѲӢt]LG{7IOugBgs3۞(rimJHRV~7_gwզ_a7ԛrgi/_t_׍D^$OnRMo1QHY%򒥯+ڋg00aS#Qd|{0_^5⬏GD5{F:K{ۙ4up] al}
{="Ixe<23p_G5^Ioҟxep/!NfWI>EMS^_[?3.Ӏ}}41&Z&|v&;PK%?#u/ 竈H}>(g뚏@w*o8ւg_]}IV'k[D.DxǦmsa&ō;'ʳJ_l?)g9$}~Z׻7Ii֛Mo6pn.z^~{[VΛ-tuᾹc=]$fd:/py{߆+_2h6i޿1e1٬.)05f^d&>%9w;rLSq	SwyI'L{L6OIݻ,k=I}k6'~|.lɮk<| Rw6IhB%H (8Ǚ+GF;1ev.'b*\G5qT(r-S*R#sLɡB\\AF-'pA'X93X4
]V"n5.v,Ĺ۶i;\L",jR-UYmoJ8"o6=[ݛ{RFxk;~ΚOX
W.gx/#[Z+/Q.|:=Im
i%>Z꠹=cX6{Z]Zf;Ǵѷ6:,NI=OiXpqMozcȧ5:k(~Ņߍ:iׄ4g{=r}^hw%}>LW&2H2A*F*L|LIe -RRd2kޜTT22kV|T2ڟ/T"2dev\ އLL
2dA*?T22& ?)A&LLݤ2dז_"7H2d|LHe -6Hm2def;2`NF$Lts/	I ,$VIXx2٪fǣ0s\QQ:h⸠NĒ
}ZISΟKԽ(%\d0
mZp$eF[F(B	"pI`"A׷ݧ=gIB#wMg\X1Vg1dDg$3L|It&4:!ROV;y^@'d7RSyc15'kρA戕_3⨳$S=[PbJ[F%zQQ]i|YlTmeL@TE߮v
k!t8qC蕤Ԕ$fMp}!г,WGtWryr#.gMhOX=lTk"[Š'uqJ7edԎ-Rplg.ɣ9]Sت$\O`T/Z\-St!Q
^J=y&KHL:Ӛؔx,Q]^3^Y;m{\A+eylgK1)%K4YȎ8ʚPg}(2&	HJ-idO&nTt3r5=Yl7{hS4ǵtmGCVD=<|u5&Ձ(!jYvnzp(b;I1#S5zfmWjwVG˓+&`8:mm/VV5Q $5Y,(z?h1ڄ=)2w*Av88/WK9mQtHNms(K1Lżte-f:_Ghx`Ptb}gwVYG]ُ5.;c3S|օF~2eŒ@a2/8Eε2DzO*YNJ\0쁺-cDъN>Ps#ϟ7,blN2%Qo|]eLٰFr"!f**\hO}.	fkKԑmʝI6uH%RIH((yG K51]dP/ܘ/ppQsOu=KeU}E[A-Pxkҡ0֤L;\	"#S5v[Bڍup܄^;(
jnTsdr,9bh%EJntWbOdn'_vni\;@}>iZ͔X
:vjh5%t	RoN'{]	nv'v_Z^v㡊[eB{>]񺖂!(
^WFIXYj&kÆqAS0btL2:L N.#R()E Zդr/$y+RFZ|[vƜͰ6fspna#>ɲr[f)ic1+X)v8elwb$!;pǻRtreYUlvT{RhsjE<ObU\74E,OZO*uh0pqS	@WF3Sffӻ#G]cU$HaNn4B)ˆ'qutN	z`]Zj"-kEJu-нdJ9ԼYOR'qZ.bAHyolũLj|Bg0A4kْml)-bvvގAH<6: =RL7I-,PӛҵHgKX&w-5L9zEHVS<9ecf=[s<wbL:(h7N2
if֛ިV-CNg[#$,[ִ*E\wl^LM%'~"jsyAy:]AxoT4&RGEu3FCW[\Η c1ˑp2}E:|0޴wJȀhkPG's|̩Qu
̀[KaKzZuC3($un]+w2->WvrNu=,X,Yq~JdU]?[K&F-4ْ5U,/ZǕp{́.;ⴓxyOj;],#t.l+2ɩs@G=D'm4maMwJwQ &Sk֓Q(zq;7xb=䀲u}+$::
i|;U:mQ{"d[c=6KMP LMڍ{r~r?;x92/wWlu۔uDg;Mpo|Uv=n,m\۪YGL"PT 
QG؎cO)#7`:dzg=bE\;و;mE4fLc P%.mP썔h
&i
eK1
1F;g1-h;FO0Fi&q	=?
\!jקNŖ5
VŲYTZsjvmr@]6(5kb$x2e#EjKhιJNQ%X;b

9^mLWW~o3N[$P_2!:1	&FƼ+"%ns$}WCx\#7FZ6갶>s}T$V1ٛȘpTe滃Aԛe=r);YLTu=%	-+N^U($6SߩOPEr2,9;S\VP61)GiU+R”'̚c9bV(jZCHM2nvk8߻;)2#mgqst^3C-`olS3CcgЫt5-S8
vbucz4]+7yQf'"<'я4ԪMhgj:.1*/d%mM42G!l(A#T%hXPmJ*焈	5ݭN4IN;/-حΉ8Lw'RlDfCcYTVCɇ4@ƆgUζ0+[xruRgԒX,Z&fs5j;嘢X)7+XcAz֛~l7
5Y0MMJzgq>߅\"#JsY=9n{t /JmlNO
LF|̡.'p!k<&?dnSˊ]آwf1VK8Y`CL$ޯmDh>jy^-"}Z垴(ymZn,c:
\	5WXٸnB[ƪk>F [02gP2[tLd*O쫦xTMAYؗuiMѤuX`0BAعIv.Ux.>$ޭa~>v7
g2Q%mwECQv/vySx!N$;~[!EFк]u#-N^hES{^Eʎ䧽Jۥ릀ƍz|@/>ye`W:PFmSL14auе}H(QҳyÄ2b"JVØ-	E4}\qfnV\`΀jU#yT_Y&INjl]SY#C\pa+o(嶎
BkŐӏ3X+E

u=4tl^2nY,8vdEzBq*t|gّwSHdJ5m6ubDpp/q8qWKm.IcD)a$6iy`"lrĉUЛk":lO4na?%uiSꎩ0G,(b{xNbjl(:!HtGEpւh,H?-*z*#r/]AtGבDbRRU ӈM
 !%7hPoYAnnnQ2WRRPKyEyܴ0u
͹(
)\+Cc#>w
n`mlm-eS<ZΑ"ݭNƚi|#uOR+&xgEǚF#BeNԭk5[;[!"հ(T#V8/$
vY	BX)^>93K0R>X$6d3EMA[w'K'GDG~qT*)VfNɧƊD#X2EuP=GwqS<3^"F\l"qD'KE-8G3,X%昅~e[yJcGEx>4=1Lڳs8t((ơtUq}%blgNKaҮ)=R&	_)ҦwEz>Ɲ!Ng4E"
3V\r;Neahw|1v+E^uInƛ$D\;Sj(UM:lFsw4ay]..f7'e<ӽ0}%VvJ \)z974Fɢ%5-`M	MYR.mLy}`
7fKwes
:geXJ!dl7]tװׂ;"Ogf&Dp㑧%zzA1neT
)*{%*(	d~/ϦFzeQ5;<3׌^A02Wh$3فy"L.RAeC^XU48ǧDnh0b}M	N9aMDelTLr,D0Ϯgnv	I&3xnqL
%KOY)[PҞ`75P
1%[BX&Vf+Kzq9{vh
ιqӴ@Y0ҾkTpD|1;e4Eȅ$/1!gƁ>֖t &<^RD2CT;Bg"f!AYx9ɄJ:F6ggv3XLA3nItqtssQקߞgN'eTxifuczXh6v8m;#e)1,06+1*ŗ-<h(G>.Pse2QM	f"S'm56;LVЇ-~ISBAlwS.9w+->;ֵ%	KھYC1Q=5)njݖʷ(,Jp)xVbSŊ〘ZUږ!ӔB'z^MSe}\|ӓc~޴=2^J*xvwx	`Yk
DNTvMœ;~eSOkm:3-V	'Q8`S`"[[5[G6N`,'̲8su͒(̃J!sQyu[~lowH9lF9\B{'\\XiW/MXx(nvf $SCeGn\
YB˸.kĝ>jdv"+'IiWNjH*1
UZ)Mz=Ɗ+WGeRh LR@"c\aR_GjN&4brLt`eh=^F#䞖]X1Yi˩XEg-:)p5(͋#M"J9j)e,ϞV+ۈC#ژيAF	@b
c{	s>Q?Y.},6w./6koyƳjLlcV^eeo6"8o ٯ~#򻷽?yC[_yOƛn0zA <3`ƙGqUY\M˼}|n>PK]pPAPK|qR:
 tr_LogDDLEvents.sqlUT
ZR`9[R`9[R`uxVQo8~%9i2CfȜv
P(hg[>nd;N[Êa)"?(ۺxl#WW"R"/ܱ GpO	R%g%жl+܉"I Rf(n2Kf@,!؈:M,mW6:FrGzl((ٖoWt9L}wN>,\&n~qt@3yr/ph:DnTiZVumw<3\BHy
̈́9,a៊+T[f'o
BUPUAW̯2ss]te"CYv8BJb6!+&T6aLF1E'QRŘm}HFTc8"%P	lD'*FXCMi@]߉b	e	n`Dl+
'Cג+
&i 5_A@?p4\OP|t}2^N֙m]$7K0mǶPӘO? ե+.m3SlgNpk:Hy)R~4H{xd*1;?/BT){2=Dp"d̉hS¼
ŒIuE?5$2|0
'0b}j	YRq:-~~?sпw+۴]x!b1isM2uBiF`P'euzwh<a͠?]z8~ӴN
@ԫPKn	db:
PK|qRA __MACOSX/._tr_LogDDLEvents.sqlUT
ZR`9[R`[R`uxc`cg`b`MLVVP'100i ɑ(at0Z1'8D\ĂT=ҼԢb=Լ̒Ɠ@qԊ׼̼t@BA
&'85%%$U9 j `PZThⓘcTP_Un_mbnldfd^[ԜTY\b`p-,83?/ $#^@ 4/%'53%5$3-3H!^@Q?$5Whafrb	P}>)% gy(/.o
u8#44$M$6*($>f$ sqΥ%W\dRo_eoaT@RGօ~ߴoQʲQvJ{g+tXgk:shңPKGD*LAPK4z>]pPA: SQLAdmin2008Reports/SQLAdmin2008Reports/DDLHistory2008.rdlUT
WN][uxPK|qRn	db:
 Btr_LogDDLEvents.sqlUT
ZR`9[R`9[R`uxPK|qRGD*LA G__MACOSX/._tr_LogDDLEvents.sqlUT
ZR`9[R`[R`uxPKU	J