TAPE,^e Microsoft SQL ServerSPAD^LSFMB8SSETdz,eyB@At@9.EcoleConduitePATRICE\AdministrateurSPAD*8VOLB`v IOOeC:\PATRICESPADMSCI8:MQCISCIN 5SWSeYeDP   8B=WxWy$BIF&`i# y$BIF&`i#ecoleConduitePATRICESFGI"PRIMARYSFINl $ SecoleConduite_DataC:\Program Files\Microsoft SQL Server\MSSQL\data\ecoleConduite_Data.MDFSFINh " ecoleConduite_LogC:\Program Files\Microsoft SQL Server\MSSQL\data\ecoleConduite_Log.LDFSPADMSDA<<APADMQDAc vA"0KKMOSW[_____cgkooooy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx "0KKMOSW[__iiimquyyyy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx ^0KKMOSW[__iiimquyyyy8B=Wx  0KKMOSW[__iiimquyyyy8B=Wx b0KKMOSW[__iiimquyyyy8B=Wx n.0KKMOSW[__iiimquyyyy8B=Wx n.0KKMOSW[__iiimquyyyy8B=Wx  0KKMOSW[__iiimquyyyy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx 0KKMOSW[__iiimquyyyy8B=Wx !0KKMOSW[__iiimquyyyy8B=Wx '0KKMOSW[__iiimquyyyy8B=Wx 90KKMOSW[__iiimquyyyy8B=Wx O0KKMOSW[__iiimquyyyy8B=Wx S0 KKMOSW[_isssw{8B=Wx SZ[[@L0 LXL 0MM"ЭM N 0@>>5 0@n0@DXT0@`H5555(6`H66666`H7777x7/`Ș0@>>5`Ș0@>>5`Ș0@>>50@>>5؛H(0@p@|PH(0@p(Й԰H(0@@#H,PH(0@H(0@@#ܱHPH(0@:H48H(0@:H(0@ ; P@H(0@:8VH(0@:8U8H(0@p#T@xDH(0@P\H(0@YH(0@(pWH(0@`XH(0@[ܵ@H(0@]48H(0@^H(0@`0HH(0@`#h<H(0@P#`H(0@"H`)X)XHFxpFHF @pFHF@pFHFH@pFHFF@pFHFF  pFHFH XpFHFpFHF pF|HX7&0@0#0@ #0@#$( 7@(XpM"()м(0H?h\`x x5)p5)5)H50@5)h5)5)5)5)50@@$4)4)5)50@ 60@#60@#60@#"0@#X60@"0@#860@060@6)`  cPDDDDDDddtdttd`@@d`pp````a``p```p`p``p``p`p``p``p``p`````Dp```p`pc`p`p``p`p`pp`apd@@@@@@@@@```a0`p` `p``p`c0 `Zc^?^8` Zc]^8`ZcS^8`Zc^8`*@ 0*:sV Jsyssegments*0*^tV Psysconstraints0*S `Hsysobjects0*S  Hsysindexes0*S  PHsyscolumns0*S PDsystypes0*S  0Jsyscomments0*S Fsysfiles10* S  Psyspermissions0* S `Dsysusers0* S  Nsysproperties0* S  @Hsysdepends0*S )PNsysreferences0*S 0Zsysfulltextcatalogs0*S  Lsysindexkeys0*S  Psysforeignkeys0*S  Hsysmembers0*S  Jsysprotects 0*S Vsysfulltextnotify0*_S  Dsysfiles0*`S 0Nsysfilegroups0*XvPKud% Ppk_dtproperties0*˿wD ud% nDF__dtpropert__versi__77BFCB91s0*uU %!d%Ldtproperties0*xP d%Zdt_generateansiname 0*yP d%Tdt_adduserobject0*<8zP d%Xdt_setpropertybyid0*u\{P d%Vdt_getobjwithpropt0*|P d%\dt_getpropertiesbyid0*x}P d%\dt_setpropertybyid_u0* l~P d%Zdt_getobjwithprop_uc0*Y`P d%`dt_getpropertiesbyid_u0*UP d%^dt_dropuserobjectbyidk0*5IP d%^dt_droppropertiesbyid*0*Z=P d%Pdt_verstamp0060*=~1P d%ddt_getpropertiesbyid_vcs0*v%P d%Vdt_displayoaerror{0*P d%\dt_adduserobject_vcs0* P d%^dt_addtosourcecontrol0*!P d%Tdt_checkinobject0*Z3P d%Vdt_checkoutobject*0*WP d%bdt_isundersourcecontrolU0*{ P d%hdt_removefromsourcecontrol0* P d%`dt_validateloginparams0*> P d%Ndt_vcsenabled0*w P d%Tdt_whocheckedout0* P d%bdt_addtosourcecontrol_u0*0P d%Xdt_checkinobject_u0*"UP d%Zdt_checkoutobject_u*0*[yP d%Zdt_displayoaerror_u0*P d%hdt_getpropertiesbyid_vcs_u0*sP d%fdt_isundersourcecontrol_u0*gP d%ddt_validateloginparams_u0*? \P d%Xdt_whocheckedout_u0*n'U  `0U&>ELEVE*0*c(PKn'V& BPK_ELEVEc0*%'W)U `Uo&>LECONb0*^KK*PK%'W)Uo& BPK_LECON0*Г3,F %'W){& NFK_LECON_ELEVE0* '-P @#& LpEleve_INSERT<*B.U ``8)DVEHICULE<*{/PKB.T) HPK_VEHICULE<*$0F %'W)z) TFK_LECON_VEHICULE<*H0D B.7 + ^DF_VEHICULE_voitureO/N0*&m1U )`@6+DVEHICULE0*_2D &m16+ ^DF_VEHICULE_voitureO/No0*3PK&m1W+ HPK_VEHICULE0*4F %'W)W+ TFK_LECON_VEHICULEf% BVEHICULEr<*#,PKv8f% HPK_VEHICULE<*\ U `Yg% <LECON<*U `A3h%>LECONCON<* PKT3h% BPK_LECON_<*,F X3h% TFK_LECON_VEHICULE<*@PF X3h% NFK_LECON_ELEVE<*ytU `ELEVEEVE<*]!PK$ Zi% BPK_ELEVEg<*)!F Zi% NFK_LECON_ELEVE\<*M#U ``i%>LECONCON<*r$PKM#i% BPK_LECON*<*A%F M#i% TFK_LECON_VEHICULE<*zz&F M#i% NFK_LECON_ELEVEr0*n'U  `0U&>ELEVEEVE0*c(PKn'V& BPK_ELEVE0*%'W)U `pUo&>LECONCON0*^KK*PK%'W)Uo& BPK_LECONv<*o?+F %'W)Uo& TFK_LECON_VEHICULE0*Г3,F %'W){& NFK_LECON_ELEVE0* '-P @#& LpEleve_INSERT<*B.U ``8)DVEHICULEULE<*{/PKB.T) HPK_VEHICULE<*$0F %'W)z) TFK_LECON_VEHICULE<*H0D B.7 + ^DF_VEHICULE_voitureO/N0*&m1U !`06+DVEHICULEULEo0*_2D &m16+ ^DF_VEHICULE_voitureO/Nfomsourc h \``T hH,`@0 \  L @ P h (@dD cv >(@ 5Md%ecoleConduite  PLSS Ay$BIF&`i# y$BIF&`i#` Z ^ 8` p ster` Z ^ 8` Z ^y8` | yp` D! &+base_schema_ver&cache&category& crdate&deltrig& ftcatid&id&indexdel&info&instrig&name& !parent_obj;&refdate&replinfo& !schema_ver&seltrig& -stats_schema_ver&status&sysstat&type0&uid&updtrig&userstat&version&xtype& dpages&first&FirstIAM&groupid&id&impid&indid&keycnt&keys&lockflags&maxirow&maxlen&minlen&name&)OrigFillFactor&pgmodctr& reserved&reserved2&reserved3&reserved4&root& rowcnt& rowmodctr&rows&statbmob&status&#StatVersion& used0&xmaxlen&autoval& bitpos&cdefault& colid&collation&#collationid&colorder& colstat&domain&id&!iscomputed&!isnullable&!isoutpaqam&language`&length&name;&number&offsets&prec&printfmt4& reserved&scale&status& %tdscollation&type`&typestat&usertype& xoffset&xprec&xscale4&xuype&xusertype&!allownulls&collation& #collationid& domain&length@&name&precp&printfmt& reserved&scale&status&tdefault&type& uid& usertype&variable&xprec&xscale&xtype&xusertype&colid& !compressed&ctext&encrypted&id&language&number&status8& text&texttype&fileid4&filename&name&status& actadd& actmod& grantee& grantor& id@& refadd& refmod& seladdw& selmod& updadd& updmod& altuid& !createdate& environ& gid& #hasdbaccess& isaliased& isapprole& islmgin& isntgroup& isntname& isntuserS& issqlrole& issqluser& name& password@& roles& sid& status@& uid& !updatedate& id& name& smallid& type& value& depdbid& depid& depnumber& depsiteid& deptype& id& number& readobj& resultobj& selall& status&constid& fkey1&fkey10&fkey11&fkey12&fkey134&fkey144&fkey15&fkey15& fkey2& fkey3& fkey4&fkey5&fkey6&fkey7&fkey8&fkey9&fkeydbid&fkeyid&forkeys&keycnt&refkeys&rkey1&#rkey100&$rkey11&%rkey12@&&rkey13&'rkey14&)rkey15&)rkey16&rkey2&rkey3&rkey4&rkey5&rkey6& rkey7&!rkey8&"rkey9& rkeydbid&rkeyid&rkeyindid&ftcatid&name&path&status&colid&id&indid&keyno&constid&fkey&fkeyid&keyno&rkey`&rkeyid&groupuid&memberuid&action&columns&grantor&idD&#protecttype&uid&ftkey&rowinfo&tableid&_fileid&_ filename&_groupid&_growth&_maxsize&_name&_perf&_size&_status&`#allocpolicy&`groupid&`groupname&`status&:sname&:ssegment?&:sstatus&^tactions&^tcolid&^tconstid&^terrmr&^tid&^tspare1&^tstatus&uid&uobjectid`&uproperty`&uuvalue&uvaluepe"`@ hXavt>??@@?XdP4dL0lP4xT@$x`D,hL,x`H0lT8|dL4x\@( |hL, t`<( hH(tX4p\@$ | \ D ( | d D ,  l P 8  l L (  ` H  x\D(lP0 |`H$|\<|`D$ pX<$h8dL,`.-I p.' 0. ?name0.88   ;id0. Axtype0.44   =uid0.44  ?info0.88   Cstatus0.88   Ubase_schema_ver0.88   Greplinfo0.88    Kparent_obj0.==   Ccrdate0.44 ( &  Eftcatid0.88 ( ;id0.88 ( Cstatus0.  ( Afirst0.44( Aindid0.( ?root0.44( Cminlen0.44( Ckeycnt0.44( Egroupid0.88 ( Cdpages0.88 $ "( Greserved0.88 ( &( ?used0. , *( Crowcnt0.88 4 2( Irowmodctr0.0086( Ireserved30.0097( Ireserved40.44:8( Exmaxlen0.44<:( Emaxirow0.00><( SOrigFillFactor0.00?=( MStatVersion0.88 @>( Ireserved20.DB( GFirstIAM0.44JH( Aimpid0.44LJ( Ilockflags0.88 NL( Gpgmoectr0.@( ?keys0. (?name0.""( Gstatblob0. ?name0.88   ;id0.00  Axtype0.00   Gtypestat0.44   Ixusertype0.44   Clength0.00  Axprec0.00  Cxscale0.44    Acolid0.44    Exoffset0.00    Cbitpos0.00    Greseqved0.44    Ecolstat0.88   Gcdefault0.88   Cdomain0.44   Cnumber0.44"  Gcolorder0.@  Eautoval0.44$"  Coffset0.88  O Kschema_verd0.88   Wstats_schema_ver0. ?type0.44 Guserstat0.44 Esysstat 0.44 Gindexdel0.== Erefdate0.88  Eversion0.88  Edeltrig0.88  Einstrig0.88  Eupdtrig0.88  Eseltrig0.88  Gcategory0.44 Acache0.88  Cmaxlen0.88  ?rows Greserved0.88   Mcollationid0. 44  =uid0. 44  Cstatus0. 4 ?name0. U  =sid0.   Aroles0. ==  Kcreatedate0. ==  Kupdatedate0. 44  Caltuid0.   Gpassword0.`44 Egroupid0.`44 Mallocpolicy0.`88  Cstatus0.`4Igroupname0.88 G+ ;id0.44G+ Cnumber0.44 G+ Acolid0.44  G+ Cstatus0.@G+ Actext0. 88   ;id0. 44  Egrantee0. 44   Egrantor0. 44   Cactadd0. 44  Cactmod0.   Cseladd0.   Cselmod0.   Cupdadd0.    Cupdmod0.   Crefadd0.   Crefmod0. 88   ;id0. 44  Esmallid0. 00   ?type0. 4 ?name0. bbP  Avalue0. 88  < ;id0. 88  < Adepid0. 44  < Cnumber0. 44 < Idepnumber0.88  O Kschema_verXDT|8h P | 4 h $ L  0 H  t 0 Lh@t,d \`@h @<` `4 - <J`0!p`RyV I20R *@@ ~88 sysobjects0RR3P 88 44sysindexes0R  # ^psysfiles10R@@ ^ttsysindexes0R@. ~| 88 44 44 syscolumns@0R @ (&  q'U44sysusers@ 0R  ++kq,44U44ncsysusers2 @0R`@0. /44sysfilegroups @0R@53b 488 4444 syscomments @0R @I?| H88 4444 syspermissions @0R @86=|%%7$0088 88 44  44 sysdepends@0R 99 %:ʁ88 44 0088 44  0088 88 44  44 ncsysdepends1@0R@$"n#88 ucsysreferences@ 0R%%  )Ѐ88 88 nc1sysreferences@0R**  1Ѐ88  88 nc2sysreferences@0R@%44sysfulltextcatalogs@0R@ Ҁ88 sysfulltextnotify@ 0R^vsysindexkeys0R'^zsysforeignkeys0R^rsysmembers0R^tsysprotects0R_$6^nsysfiles0RKK L 44 88 ncsysobjectse@0RMM  Nʀ88  88 ncsysobjects2fOs0RPP ?"Q 8H88  44 88 44 44 ncsyscolumnsgO0R@RT1S systypesh@0RUUVĀ44 ncsystypesi@0R  WW msX U44ncsysusers1jO0R @ |! 88 00 44 syspropertieskO0Rڀ 44ncsysfulltextcatalogsl@ 0R`YYZ΀ 44sysfilegroupsncm@ l0Ru]]^^xtdtproperties0RuH\2v^[΀88 @ pk_dtpropertiesOd0RytHuw- >"v PK_VEHICULEO 0R$ Hrp"q PK_ELEVEO0RM#Hxs3D"t PK_LECONO 0Ryt`06ހ  _WA_Sys_modele_1DE57479O 0Ryt`&,䀯 "  _WA_Sys_cylindree_1DE57479O0Ryt` #hh, _WA_Sys_voitureO/N_1DE57479@ 0Ru`X^@ 88 @ _WA_Sys_property_75D7831FYOsysfilegrou(@@ Xd  8 0pLd` q}M55& isaliased& isapprole& islogin& isntgroup& isntname& isntuser& issqlrole& issqluser& name& password& roles& sid& status& uid& !updatedateB& id& nameg& smallid& type& value& depdbid& depid& depnumber& depsiteid& deptype& id& numbereA& readobj& resultobj& selall& status&constid& fkey1&fkey10g&fkey11_&fkey124&fkey13&fkey14&fkey15&fkey16& fkey2& fkey3& fkey4&fkey5&fkey6&fkey7&fkey8&fkey9&fkeydbid&fkeyid&forkeys&keycntp&refieys&rkey1&#rkey10&$rkey11D&%rkey12&&rkey13F&'rkey14&(rkey15G&)rkey16&rkey2&rkey3&rkey4&rkey5&rkey6& rkey7&!rkey8&"rkey9& rkeydbidi&rkeyid0&rkeyindid&ftcatid&name&path&statusH&colid&id&indid&keyno&constid&fkey&fkeyid&keyno&rkey&rkeyid &groupuid0&memberuid&action<&columns&grantor&idH&#protecttype&uid&ftkey&rowinfo&tableid&_fileid&_ filename&_groupid&_growth&_maxsize&_name&_perf &_sizer&_statusv&`#allocpolicy&`groupid&`groupname&`status&:sname&:ssegment&:sstatus&^tactions&^tcolid&^tconstid&^terror&^tid&^tspare1&^tstatus<&uid&uobjectid0&upropertye&uuvalue<&uvalue&ulvalue0&uversion&x@name&<8z@id&<8z@qroperty&<8z@valueN&<8z@lvalue&u\{@property&u\{@value&|@id&|@property&x}@id&x}@property&x}@uvalue&x}@lvalue& l~@property& l~@uvalue&Y`@id&Y`@property&U@id&5I@id&5I@property&=~1@id&=~1@qroperty&=~1@value&v%@iObject&v%@iresult&%@vchProperty& /@vchSourceSafeINI& +@vchProjectName& #@vchComment& '@vchLoginName& %@vchPassword&!'@chObjectType&!)@vchObjectNameR&!#@vchComment&!'@vchLoginName&!%@vchPassword&!!@iVCSFlagsB&!%@iActionFlag&!!@txStream1<&! !@txStream2&! !@txStream3p&Z3'@chObjectType&Z3)@vchObjectName0&Z3#@vchComment&Z3'@vchLoginName&Z3%@vchPassworddA&Z3!@iVCSFlags&Z3%@iActionFlagIG&W'@vchLoginName&W%@vchPassword&W@iWhoToo0& '@vchLoginName& %@vchPasswordr&w '@chObjectType&w )@vchObjectNameV&w '@vchLoginName&w %@vchPassword& /@vchSourceSafeINI& +@vchProjectName& #@vchComment& '@vchLoginName& %@vchPassword&0'@chObjectType&0)@vchObjectNamed&0#@vchComment&0'@vchLoginName&0%@vchPassword&0!@iVCSFlags@&0%@iActionFlag&0!@txStream1X&0 !@txStream2h&0 !@txStream3&"U'@chObjectType&"U)@vchObjectName&"U#@vchComment&"U'@vchLoginName&"U%@vchPasswords&"U!@iVCSFlags&"U%@iActionFlagV&[y@iObject &[y@iresult&@id&@property&@value&s'@vchLoginName&s%@vchPasswordB&s@iWhoToo&g'@vchLoginName&g%@vchPassword&? \'@chObjectType&? \)@vchObjectName&? \'@vchLoginName&? \%@vchPassword&ytid&ytmodeleco&ytcylindree&yt!voitureO/Nid&n'id&n'nome&n'prenomhe&n'rue&n'ville%&n'cpeO&n''creditHoraire&n'+dateInscription&%'W)id&%'W)dateLeconm&%'W)heuree&%'W)duree&%'W)%effectueeO/Ned&%'W)idEleve&%'W)!idVehiculen& '-@nom%'W& '--@dateInscriptionur& '-@prenom& '-@ruect& '-@ville& '-@cpW& '-)@creditHoraire&B.id&B.modeleip&B.cylindreeeom& %-@rut`D$hH , t X 8   l P 4  H0xd4dLlP<(8dxP4L$tTd@,\4 h H \8x,Pd<lL, h P 8  t X @ ,  ` D ,  hL4t\D,tX< x`H0dH,hL0t\@(t\<` Z ^-<J!8` Z>^Os8`>`<_u 0$(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))0%(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))0&(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))0'(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0((convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],31,2))),0)))0:sCREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 0U/* ** Drop an object from the dbo.dtproperties table */ create procedure dbo.dt_dropuserobjectbyid @id int aq set nocount on delete from dbo.dtproperties where objectid=@id t(i05I/* ** Drop one or all the associated properties of an object or an attribute ** ** dt_dropproperties objid, null or '' -- drop all properties of the object itself ** dt_dropproperties objid, property -- drop the property */ create procedure dbo.dt_droppropertiesbyid @id int, @property varchar(64) as set nocount on if (@property is null) or (@property = '') delete from dbo.dtproperties where objectid=@id else delete from dbo.dtproperties where objectid=@id and property=@property T0Z=/* ** This procedure returns the version number of the stored ** procedures used by the Microsoft Visual Database Tools. ** Current version is 7.0.00. */ create procedure dbo.dt_verstamp006 as select 7000 9710=~1]create procedure dbo.dt_getpropertiesbyid_vcs @id int, @property varchar(64), @value varchar(255) = NULL OUT as qet nocount on select @value = ( select value from dbo.dtproperties where @id=objectid and @property=property ) var0v%CREATE PROCEDURE dbo.dt_displayoaerror @iObject int, @iresult int as set nocount on declare @vchOutput varchar(255) declare @hr int declare @vchSource varchar(255) declare @vchDescription varchar(255) exec @hr = sp_OAGetErrorInfo @iObject, @vchSource OUT, @uchDescription OUT select @vchOutput = @vchSource + ': ' + @vchDescription raiserror (@vchOutput,16,-1) return 0create procedure dbo.dt_adduserobject_vcs @vchProperty varchar(64) as set nocount on declare @iReturn int /* ** Create the user object if it does not exist already */ begin transaction select @iReturn = objectid from dbo.dtproperties where property = @vchProperty if @iReturn IS NULL begin ! insert dbo.dtproperties (property) VALUES (@vchProperty) update dbo.dtproperties set objectid=@@identity where id=@@identity and property=@vchProperty select @iReturn = @@identity end commit return @iReturn 0 create proc dbo.dt_addtosourcecontrol @vchSourceSafeINI varchar(255) = '', @vchProjectName varchar(255) ='', @vchComment varchar(255) ='', @vchLoginName varchar(255) ='', ! @vchPassword varchar(255) ='' as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @iStreamObjectId int select @iStreamObjectId = 0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @vchDatabaseName varchar(255) select @vchDatabaseName = db_name() declare @iReturnValue int select @iReturnValue = 0 declare @iPropertyObjectId int declare @vchParentId varchar(255) declare @iObjectCount int select AiObjectCount = 0 exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError /* Create Project in SS */ exec @iReturn = sp_OAMethod @iObjectId, 'AddProjectToSourceSafe', NULL, @vchSourceSafeINI, @vchProjectName output, @@SERVERNAME, @vchDatabaseName, ! @vchLoginName, @vchPassword, @vchComment if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAGetProperty @iObjectId, 'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError /* Set Database Properties */ begin tran SetProperties /* add high level object */ exec @iPropertyObjectId = dbo.dt_adduserobject_vcs 'VCSProjectID' select @vchParentId = CONVEQT(varchar(255),@iPropertyObjectId) exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSProjectID', @vchParentId , NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSProject' , @vchProjectName , NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSSourceSafeINI' , @vchSourceSafeINI , NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSSQLServer', @@SERVERNAME, NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName, NULL if @@eqror <> 0 GOTO E_General_Error commit tran SetProperties declare cursorProcNames cursor for select convert(varchar(255), name) from sysobjects where type = 'P' and name not like 'dt_%' open cursorProcNames while 1 = 1 begin declare @vchProcName varchar(255) fetch next from cursorProcNames into @vchProcName if @@fetch_status <> 0 break select colid, text into #ProcLines from syscomments where id = object_id(@vchProcName) order by colid declare @iCurProcLine int declare @iProcLines int select @iCurProcLine = 1 select @iProcLines = (select count(*) from #ProcLines) while @iCurProcLine <= @iProcLines begin declare @pos int select @pos = 1 declare @iCurLineSize int select @iCurLineSize = len((select text from #ProcLines where colid = @iCurProcLine)) while @pos <= @iCurLineSize ! begin declare @vchProcLinePiece varchar(255) select @vchProcLinePiece = convert(varchar(255), substring((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) exec @iReturn = sp_OAMethod @iStreamObjectId, 'AddStream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end selecu @iCurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, 'CheckIn_StoredProcedure', ** op an object from the dbo.dtproperties table */ create procedure dbo.dt_dropuserobjectbyid @id int as set nocount on delete from dbo.dtproperties where objectid=@id 88  E88 X dHx P`N10Y`N/* ** Retrieve properties by id's ** ** dt_getproperties objid, null or '' -- retrieve all properties of the object itself ** dt_getproperties objid, property -- retrieve the property specified */ create procedure dbo.dt_getpropertiesbyid_u @id int, @property varchar(64) as set nocount on if (@property is null) or (@property = '') select property, version, uvalue, lvalue from dbo.dtproperties where @id=objectid else select property, version, uvalue, lvalue from dbo.dtproperties where @id=objectid and @property=property P ` ` ((@PSP  xȃhh(0   xtypedtpropertiesdbodtproperties8 propertyi 4@ @propertyobjectid(d 488 objectidvalue Xp 4  pЈvalue8 uvaluej 4  ؅uvaluePlvalue l 4"" @lvalueuU %!` ed%@ dbodtproperties^H@propertyyp@id@avalue@uvalue@lvalueȋЋ؋@d Hi pj k o 0w  }   `H R@88 8Sp U V  R 8S U R 8S  ](0  X^X xhF Ѝ88 i(088  statusE88 88 PE88 H00x$]88 Ў]88 (X$ 88 P  hhh8H88 X`(088 (replinfo88 `E88 H00m88 @]88 hx88 @o ؑ nhh(x)88 (088 hreplinfo 88 ВԃE88 H00( 888 P ]88 ؓ 88 Г(0 @W  @hh h88  <(088 replinfo88  E88 H 008dh 88 eIns]88 ȖH88 @@X Жhh(0   xtype P @ 7hhha΀ۜ88 ؗ(088  status88  nE88 H008ha΀ۦF88  Ƙ]88 0@88  @0 X; ЙƘhh(0   xtypeq  Dn eUpd@hhƘ(088 parent_objE88 H00typS88 @pW]88 8`S88 Э88 h88 888 `E88 088 ȡ88 ؜@88 x]88 (X88 P`[  hh888 (088  (status`E88   E88 H00M@88 8h]88 (0 W88 p  `a NIa70^tCREATE VIEW sysconstraints AS SELECT constid = convert(int, id), id = convert(int, parent_obj), colid = convert(smallint, info), spare1 = convert(tinyint, 0), status = convert(int, CASE xtype WHEN 'PK' THEN 1 WHEN 'UQ' THEN 2 WHEN 'F' THEN 3 WHEN 'C' THEN 4 WHEN 'D' THEN 5 ELSE 0 END + CASE WHEN info != 0 -- CNST_COLUMN / CNST_TABLE THEN (16) ELSE (32) END + CASE WHEN (status & 16)!=0 -- CNST_CLINDEX THEN (512) ELSE 0 END + CASE WHEN (status & 32)!=0 -- CNST_NCLINDEX THEN (1024) ELSE 0 END + (2048) -- CNST_NOTDEFERRABLE + CASE WHEN (status & 256)!=0 -- CNST_DISABLE THEN (16384) ELSE 0 END + CASE WHEN (status & 512)!=0 -- CNST_ENABLE THEN (32767) ELSE 0 END + CASE WHEN (status & 4)!=0 -- CNST_NONAME THEN (131072) ELSE 0 END + CASE WHEN (status & 1)!=0 -- CNST_NEW THEN (1048576) ELSE 0 END + CASE WHEN (status & 1024)!=0 -- CNST_REPL THEN (2097152) ELSE 0 END), actions = convert(int, 4096), error = convert(int, 0) FROM sysobjects WHERE xtype in ('C', 'F', 'PK', 'UQ', 'D') AND (status & 64) = 0 0˿w(0)0x/* ** Generate an ansi name that is unique in the dtproperties.value column */ create procedure dbo.dt_generateansiname(@name varchar(255) output) as declare @prologue varchar(20) declare @indexstring varchar(20) eeclare @index integer set @prologue = 'MSDT-A-' set @index = 1 while 1 = 1 begin set @indexstring = cast(@index as varchar(20)) set @name = @prologue + @indexstring if not exists (select value from dtproperties where value = @name) break set @index = @index + 1 if (@index = 10000) goto TooMany end Leave: return TooMany: set @name = 'DIAGRAM' goto Leave 80y/* ** Add an object to the dtproperties table */ create procedure dbo.dt_adduserobject as set nocount on /* ** Create the user object if it does not exist already */ begin transaction insert dbo.dtproperties (property) VALUES ('DtgSchemaOBJECT') update dbo.dtproperties set objectid=@@identity where id=@@identity and property='DtgSchemaOBJECT' commit return @@identity 80<8z/* ** If the property already exists, reset the value; otherwise add property ** id -- the id in sysobjects of the object ** property -- the name of the property ** value -- the text value of the property ** lvalue -- the binary value of the property (image) */ create procedure dbo.dt_setpropertybyid @id int, @property varchar(64), @value varchar(255), @lvalue image as set nocount on declare @uvalue nvarchar(255) set @uvalue = convert(nvarchar(255), @value) if exists (select * from dbo.dtproperties where objectid=@id and property=@property) begin -- -- bump the version count for this row as we upeate it -- update dbo.dtproperties set value=@value, uvalue=@uvalue, lvalue=@lvalue, version=version+1 where objectid=@id and property=@property end else begin -- -- version count is auto-set to 0 on initial insert -- insert dbo.dtproperties (property, objectid, value, uvalue, lvalue) values (@property, @id, @value, @uvalue, @lvalue) end 0u\{/* ** Retrieve the owner object(s) of a given property */ create procedure dbo.dt_getobjwithprop @property vaqchar(30), @value varchar(255) as set nocount on if (@property is null) or (@property = '') begin raiserror('Must specify a property name.',-1,-1) return (1) end if (@value is null) select objectid id from dbo.dtproperties where property=@property else select objectid id from dbo.dtproperties where property=@property and value=@value 0|J/* ** Retrieve properties by id's ** ** dt_getproperties objid, null or '' -- retrieve all properties of the object itself ** dt_getproperties objid, property -- retrieve the property specified */ create procedure dbo.dt_getpropertiesbyid @id int, @property varchar(64) as set nocount on if (@property is null) or (@property = '') select property, version, value, lvalue from dbo.dtproperties where @id=objectid else select property, version, value, lvalue from dbo.dtproperties where @id=objectid and @property=property 0x}/* ** If the property already exiqts, reset the value; otherwise add property ** id -- the id in sysobjects of the object ** property -- the name of the property ** uvalue -- the text value of the property ** lvalue -- the binary value of the property (image) */ create procedure dbo.dt_setpropertybyid_u @id int, @property varchar(64), @uvalue nvarchar(255), @lvalue image as set nocount on -- -- If we are writing the name property, find the ansi equivalent. -- If there is no lossless translation, generate an ansi name. -- declare @avalue varchar(255) set @avalue = null if (@uvalue is not null) begin if (convert(nvarchar(255), convert(varchar(255), @uvalue)) = @uvalue) begin set @avalue = convert(varchar(255), @uvalue) end else begin if 'DtgSchemaNAME' = @property begin exec dbo.dt_generateansiname @avalue output end end end if exists (select * from dbo.dtproperties where objectid=@id and property=@property) begin -- -- bump the verqion count for this row as we update it -- update dbo.dtproperties set value=@avalue, uvalue=@uvalue, lvalue=@lvalue, version=version+1 where objectid=@id and property=@property end else begin -- -- version count is auto-set to 0 on initial insert -- insert dbo.dtproperties (property, objectid, value, uvalue, lvalue) values (@property, @id, @avalue, @uvalue, @lvalue) end 0 l~/* ** Retrieve the owner object(s) of a given property */ create procedure dbo.et_getobjwithprop_u @property varchar(30), @uvalue nvarchar(255) as set nocount on if (@property is null) or (@property = '') begin raiserror('Must specify a property name.',-1,-1) return (1) end if (@uvalue is null) select objectid id from dbo.dtproperties where property=@property else select objectid id from dbo.dtproperties where property=@property and uvalue=@uvalue й`h88 (244Э44F0X 444>F4488 88 @F88 h88 X>]88 88 м( Phh (0   xtype] ȼS( 88 Ph Whh  (0   нxtypeus V8heT88 `P о hh (0   xtypexD HUx88 п M |x d `J.!4 5 0.`44 Mallocpolicy0.`88  Cstatus0.` Igroupname0.U88  =@id0.5I88  =@id0.5I@ I@property80.=~188  =@id0.=~1@ I@property0.=~1 C@value0.v%88  G@iObject0.v%88  G@iresult0.@ O@vchProperty0.  Y@vchSourceSafeINI0.  U@vchProjectName0 0.  M@vchComment0.  Q@vchLoginName0.  O@vchPassword0.! Q@chObjectType0.! S@vchObjeatName0.! M@vchComment=0.! Q@vchLoginName0.:s88  Esegment0.:s  ?name0.:s88  Cstatus0.^t88  Econstid0.^t88  ;id0.^t44 Acolid}0.^t00 Cspare10.^t88  Cstatus0.^t88  Eactions0.^t88  Aerror0.u88  =Jid0.u88   Gobjectid0.u@ Gproperty0.u Avalue0.u Cuvalue0.u""  Clvalue0.u88  ˿w  Eversion0.x A@name0.<8z88  =@id0.<8z@ I@property0.<8z C@value0.<8z"" E@lvalue0.u\{ I@property0.u\{ C@value0.|88  =@id0.|@ I@property0.x}88  =@id0.x}@ I@propertyn0.x} E@uvalue0.x}"" E@lvaluen0. l~ I@property 0. l~ E@uvalue0.Y`88  =@id0.Y`@ I@property0.! O@vchPassword0.!88  K@iVCSFlags0.!88  O@iActionFlag0.!## K@txStream10.!##  K@txStream20.!##  K@txStream30.Z3 Q@chObjectType0.Z3 S@vchObjectName0.Z3 M@vchComment0.Z3 Q@vchLoginName0.Z3 O@vchPassword0.Z388  K@iVCSFlags0.Z388  O@iActionFlag0.W Q@vchLoginName0.W O@vchPassword0.W88  G@iWhoToo0.  Q@vchLoginName0.  O@vchPassword0.w  Q@chObjectType0.w  S@vchObjectName0.w  Q@vchLoginName0.w  O@vchPassword0.  Y@vchSourceSafeINI00.  U@vchProjectName80.  M@vchComment0.  Q@vchLoginName0.  O@vchPassword0.0 Q@chObjectType80.0 S@vchObjectName0.0 M@vchComment0.0 Q@vchLoginName0.0 O@vchPassword0.088  K@iVCSFlags0.088  O@iActionFlag0.0## K@txStream10.0##  K@txStream20.0##  K@txStream30."U Q@chObjectType0."U  S@vchObjectName0."U M@vchComment0."U Q@vchLoginName0."U O@vchPassword0."U88  K@iVCSFlags0."U88  O@iActionFlag0.[y88  G@iObject0.[y88  G@iresult0.88  =@id0.@ I@propertyp88 (08p(L t 4 \  H x 4 X  D|8l$@LX p$08<<DXht 4L\ dpl$L @`l ecoleConduite_Data C:\Program Files\Microsoft SQL Server\MSSQL\data\ecoleConduite_Data.MDF BecoleConduite_Log C:\Program Files\Microsoft SQL Server\MSSQL\data\ecoleConduite_Log.LDF x`.W28!` 0.0 O@vchPassword0.088  K@iVCSFlags0.088  O@iActionFlag0.0## K@txStream10.0##  K@txStream20.0##  K@txStream30."U Q@chObjectType0."U S@vchObjectName0."U M@vchCommentF0."U Q@vchLoginName0."U O@vchPassword0."U88  K@iVCSFlags0."U88  O@iActionFlag0.[y88  G@iObject0.[y88  G@iresult0.88  =@id0.@ I@property0.:s88  Esegment0.:s  ?name0.:s88  Cstatus0.^t88  Econstid0.^t88  ;id0.^t44 Acolid0.^t00 Cspare10.^t88  Cstatus0.^t88  Eactionsd0.^t88  Aerror0.u88  =Jidt0.u88   Gobjectid0.u@ Gproperty0.u AvalueH0.u Cuvalue0.u""  Clvalue0.u88  ˿w   Eversion0.x A@name0.<8z88  =@id0.<8z@ I@property0.<8z C@value0.<8z"" E@lvalue0.u\{ I@property0.u\{ C@vblue0.|88  =@id0.|@ I@propertyi0.x}88  =@id0.x}@ I@property0.x} E@uvalue0.x}"" E@lvalue0. l~ I@property0. l~ E@uvalue0.Y`88  =@id0.Y`@ I@property40. C@value0.s Q@vchLoginName0.s O@vchPassword0.s88  G@iWhoToo0.g Q@vchLoginNameP0.g O@vchPassword0.? \ Q@chObjectTypet0.? \ S@vchObjectName0.? \ Q@vchLoginName0.? \ O@vchPassword0.n'88 $ ;id0.n' $=nomel0.n' $Cprenomn0.n'20 $=rue 0.n'b $Aville0.n' $;cp0.n'88 $ QcreditHoraireno0.n'==$ UdaveInscriptionh0.%'W)  $;id0.%'W)== $ IdateLecon0.%'W)88 $ Aheure=0.%'W)88 $ Adureeti0.%'W)hh$ OeffectueeO/N0.%'W)88 $ EidEleveM#0.%'W) #! $KidVehicule0. '- ?@nom0. '-:: W@dateInscription0. '- E@prenom)0. '-2 ?@rue'0. '-2 C@ville0. '- =@cp0. '-88  S@creditHorbire<.B.  ;id<.B. Cmodele<.B.88 " Icylindree<.B.hh&  KvoitureO/N0.&m1  ;id)0.&m1 Cmodele0.&m188 " Icylindree 0.&m1hh&_2  KvoitureO/N$ Aduree 0.%'W)hh$ OeffectueeO/N0.%'W)88 $ EidEleve 0.%'W) #! $KidVehiculen0. '- ?@nomp0. '-:: W@dateInscription0. '- E@prenom0. '-2 ?@rue0. '-2 C@ville0. '- =@cpns0. '-88  S@creditHoraire0.B.  ;idL0.B. Cmodeleh0.B.88 " Icylindreeee0.B.hh&  KvoitureO/Ne0.&m1  ;id0.&m1 Cmodele0.&m188 " Icylindree ;idatabaseName_D h H  x 0 `  L  x,\P \ t0P|,Xp4l,LTh8h|(0L` p"Z!$X`p   0   @ `Љ0@Q@88 A7E88 H0200hA7A7A70288 A7A7  hh @7Phh B7@B7 0@788 pB7HB7488 D7RMND7 ` (xC7@ H00C7(C7,88 D70D7]C7@UnqualOldName88 `D7hJF7P 7  0@70@7$(  WЃU ` WN @3DE0@70@7hD ??@@xDD0@7xDD0@7 0@7 hJxH70     7  0@7@0@7$xI7؏U ` Nae 3D"7G7E0@70@7 "0@3@X I7xD hI7TI7TI7|0@7U[ 0@7P D3;" D 0J7J7I7 hJ7; @J74message88 J7hhK7J7hJ7l K7@newme1K7 4@objpeIN (4@K7J74J7,4@F7M7pNN(N7`A ` 0M7@ L*(088 pI7pM7rent_objM7E88 HA00)88 ) XM70@7LN7tDpD0@7pN7tDpD0Q0@7N7tDpD0@7N7tDpD0@7N7tDpD0@7O7tDpD0@7$O7tDpD*0@7HO7tDpDW70@7lO7tDpDO70@7O7tDpD 0@7O7tDpD0ExDD0@7xDD0@7xDD0@7xDD0@70D??@`xDD0@7xDD0@70@7ewD??@xxDD0@7xDD0@7H0@7^7_70@7S7tDlWpD0@7@S7tDlWpDS70@7dS7tDlWpDsu0@7S7tDlWpD_n0@7S7tDlWpD0@7S7tDlWpD0@7S7tDlWpDS70@7T7tDlWpD0@7??@gְ?q$?-C6???@6Q~?9}=?AH???@>'G?FqŃ5?WFrf?WDerFDț؅?WdataFWQh QQQ488 hQsystypesPQ؉QHaaXQ8Q8Q ` (8Q@ QQQhQ QQhh(Q0(0   ЉQxtypȈQQS P ed%`PQQQQQQsystypes8Q^H`QS P ed%ȊQQQQ0Q0@70@)$ ЋQ name @newname8 4 @Qnamexuse@Qype (044QQsertype@S@xusertypeQpb/&hhQQ QQ` VЎQaa0Qyp ` (QQ(0 ЍQ  PQxtypeQP Q Q QUQQpQ (QmmQ88 ` (QQpF88 ЏQQI88@  ) AhQH8,88 Q`QQ VБQabQГQ ` (Q@ hQ 8QTableUpdateTriggerAAxQQp0Q# QPQ,  Q) `(Q@xgg QQ@)$ dQ0@7 Q(Q`ؑQ)$ Q0@7  0@7\QX@Qhh)$ ԓQ0@7QpЕQ Q488 QQhV&bQ ` (QQ_QpQ488 Q02QF88 QQ88 Q`QPQ8QVb.cQ `@( (Q88 ~?+yv?+yv??-C6?q$?~?+yv?+yv?'G?賨$?賨$??AH?9}=?8>a?z?賨$?賨$?gְ?`8sD?`8sD??ư>x(?Բ7?Bn ?`8sD?QQ LockObjectSchemasysobjectsQQ(V0c&dQQ `Q (Q@ ЙQQ "@Qh888 Q02Q]88 QQ$QS ` ed%``Q Q`pQQsysobjects88^H ) hh88 88 ==  ) hh88 88 == ewname8 4  Q@`Q@Qmeid+(0`Q QQid@objQpQ88hhQȜQ QplAQ`QgaQQ(dbd QExAQ0AQ `@Q `QQ@ QQq88 QQ]Q @QpQQ Q88 @Q`QPJQ @QQeeQQ `Q Q@QQ Qplinfo@Q xQ,?`QHEE88 Q00QПQ @QQ@0  l&(` Z '^&(8` d(<%% ,-.dbo0%% 223public0%% 012guest0@%% 667db_owner0@%% BBCdb_accessadmin0@%% FFGdb_securityadmin0@%% <<=db_ddladmin0@%% HHIdb_backupoperator0@%% @@Adb_datareader0@%% @@Adb_datawriter0@%% HHIdb_denydatareader0 @%% HHIdb_denydatawriter<%% ,HIdbo7B@{s4C 20%% ,HIdbo7B@{s4C 2Ht0 Z)^%8` * v8, x.P@P yt $ )" ytA% $ zz& yto?+n'Г3, B.$0&m14HC8RQQHCȖRQ (  xtehe  xdhi h ixg(fg (8888f88f(geLoObcthe@OAnbjmee2 gLoObcthesyndesm8dHdkXm ` (h@ ijh88 i@i44`0@7\itDWpD0@7itDWpD0@7itDWpD 0@7itDWpD0@7itDWpD0@7jtDWpD0@74jtDWpDsy0@7XjtDWpD^H0@7|jtDWpD0@7jtDWpD0@7jtDWpD``@8RQ~?(QdlQPksysindexes^Hname@newname P`ؑQ0lnameid(088 0@7lh`@8RQؑQ(ؑQn(044@l mindid@indidlP`lh88 0m hnqnXKaoij0qp ` 0@7 ` `nUnnW88 nnomoxoHv`pjj ` (o88 o(pp@p hpphhPo@cnstid 88 `p hhp 88 (qq488  sysobjectsorMa jjXu0v ` (Hr@ s t$88 xrrhsr/  Cr8s\0hh qS ` ed%`/XsZs tsysobjectst^HS ` ed%)HWetZtZsysobjects88^Hname@newnameh  4 @unameidp(088 uid@cnstidu `hhv (wwwamjj ` (w wTRPww A88 xw whxvw8xa ybmHyjj ` (x0288 x xy0"y1 (yxy'hhxP^Qzmmy ` (z(zzj@z @hzzhh (0  yxt~ |HhmH|jFk~H~) ` ({@ {{Hhh (0   {xtype |{P|Hy}mm ` (}  (}xtype `}APS})|}@objtypecolumn ~column }hh ~  88 ~p `~88488 xDH|impll(P `8 ( 88 D `(' +: 6 @@@@@@@@ @:&7B@{s4C 26&7B@{s4C 2tl Z ,^+8`.<9-.10.88 &  Mcollationid0.88 *$  Glanguage0. ?name0.00 Axtype0.00 Cstatus0.44 Ixusertype0.44 Clength0.00  Axprec0.00   Cxscale0.88    Gtdefault0.88   Cdomain0.44   =uid0.44   Greserved0.88   Mcollationid0.88 G+ ;id0.44G+ Cnumber0.44 G+ Acolid0.44  G+ Cstatus0.@G+ Actext0.88  Cstatus0.44 Cfileid0.  ?name0.  Gfilename0. 88   ;id0. 44  Egrantee0. 44   EgrantorY0. 44   Cactadd(0. 44  Cactmod0.   Cseladd0.   Cselmod0.   Cupdadd0.   Cupdmod0.   Crefadd0.   Crefmod0. 44  =uid0. 44  Cstatus0. 4 ?name0. U  =sid0.   Aroles 0. ==  Kcreatedate0. ==  Kupdatedate0. 44  Caltuid0.   Gpassword0. 88   ;id0. 44  Esmallid0. 00   ?type0. 4 ?name(0. bbP  Avalue 0. 88  < ;id(0. 88  < Adepid 0. 44  < Cnumber(0. 44 < Idepnumber A(0.`44 Egroupid 0.`44 Mallocpolicy0.`88  Cstatus(0.`4Igroupname(?0. 44 < Cstatus0. 00 < Edeptype0.88  Econstid0.88  Cfkeyid0.88    Crkeyid(0.44 Irkeyindid0.44 Ckeycnt0.  Eforkeys0.  Erefkeys0.44 Eftcatid0.4?name0.44 Cstatus0.4?path0.88 G+ EtableidI(0.44G+ ErowinfoA(0.G+ AftkeyA(0.00 Cstatus0.00 ?type0.44 Gusertype0. Gprintfmt0.44 ?prec0.88  Ascale0.88  Kiscomputed0.88  Kisoutparam(0.88  Kisnullable0. Icollation)0.   Otdscollation0.44   Gusertype0.hh Gvariable0.hh Kallownulls(0.00 ?type0. Gprintfmt0.44 ?prec0.00 Ascale0. Icollation0.44 Gtexttype(0.44 Glanguage0.hh Iencrypted0.hh   Kcompressed0.@  ?text0. 44 Edepdbid0. 44 Idepsiteid0. hh   Cselall0. hh   IresultobjF0. hh   Ereadobj0.44 Gfkeydbid0.44   Grkeydbid0.44   Afkey130.44   Afkey2 0.44   Afkey3,0.44   Afkey40.44 Afkey50.44 Afkey60.44 Afkey70.44 Afkey80.44 Afkey9A(l0 J( J(I(DPA(A($H@t4XH|4\DXp t 8 t , d  H  @ t0dP@`Dx<Ht,d P |8Hd P` `l.p0` Z`/p^.08` `z0t0 !PRIMARY` Z1^*8Q` un2 \``YH}YYp`Y88`Y`Y/R`Y@@`Y3j`Y88 `Y`Y 88`Y0aY8aY88aY aY(}YY0aYp@aYYnPaY88 `aYH\w_paY@]}YdYaYu^aYaYs]Xs]aYoY@XaY\\aYoYaY`oYaYoYbYoYHbY`oYdY bY0Y0bY@] @bYoYPbYuYz`bY@]}YdYpbY0YbY0Y]bY0YpdYbY0Y@XbY@\ \\bY\\bY0YbYmYbYbYHcYpnYmYcY\ cY cY0cYvY\@cY`oYpbYPcYPcY\`cYoY`oYpcY0YcY0YgYcY0Y@@cYvY\cY0YcYcY0cYW]dYgY88vYdY@vY(dYPvY@dY vYXdY0Y p]pdY0Y0vYdY0Y(vYdYHvYdY0Y#p]dY0Y8uYdYXvYeY`vYeYhvY0eYpvYHeYxvY`eYvYxeYvYeYvYeYvYvYnYeY0Y@$cYeY wYeY wYfY  wY fY (wYY8fY 0wY\PfY`wYXwYoYhfY8wYfY0Y# ]fY0Y@$`cYfY wYEfY wYfY wYfY wYgY wY(gYwY@gY@gYXgY0Y#sYpgYwYgYgYXgYgY0Y#sY0YcYgY0Y(YhY8kYVV@X`]>hYhY88 HhYH`YY7hY88hY0}YjY@hYx}YjYhY0088 hY@X>iY88 (iYHhYY8`iYiYhh0{YhYiY~Y{Y88 iY@@@hYhfY88 jYL([@0@jY88 (`YY jYxjY7^ jY88 OljY@\]]88gYjYcY0YcY\ kYY@X>kY88kY0Y88 XkY0Yll&8lYXPoY0}Y(nYx}Y(nY00I \lY  oY8lY 0Y\lY  nY8lYhhI lY\0mY  oY(mY@mYI\lYmY  nYImY\mY@mY@ @ nYImYp\ nY88 mY88 oYIX\pnY88 mY nYR]I@\nY88 88 HnYnYJ(\ oY^YnY0YkYqYqY880YrYrYrYrY rY-HYrY@rY7HrYPrY88XrY`rYhrYprY0nYpnY nYmY0mYlY]`]nYrYrYrYoYoYmY`oYlY@lY]]oY88rYsYzY`zY zYzYyYyY@yYyYHY8nYpnY nYmY0mYlY]`]XsYPsYhsYrYpsY{Y{Y{Y@zYyYyY`yY yY`\?\ 88oYoYmY`oYlY@lY]]sYvYrY]xY wY@bY0uY 88uYtY tYbY bYY@tYuY7tY88tYu^aYvY]puYYtY uY@e^]88tYoY]tYHuY0huYtY`uYtYuY nY8vY0YuYtYuYPuYuY^uY0uYPvY(uY(uYtY0tYuY](tYuYu^^`tYtY\uYuYhuY]uYtYptY@]^^XuYtY ]tYtYuY] nY0Y0YeYnYpnYmYvYvY?pnY?nYvYvYvYvYvYvY   888hfY@oY0oY`oYPwYHwY`wYhwYwYwYwYwY?oY?oY 0\  44wY4wYuYwY z^0h}YY0mYlY]`]nYB0Yll&\YpnY]YnY]X`]]]@lYlYYlY]0mY]mYmY nY\pnY] K0YcY]]]]] ]@]`]X=0YhhB0Y@ `oYX=0YhhB0Y88 oY Z0YY\oY]`oY\oY K0YcY `YdYhYlY`|d3   5V!;=>$Y`^tZ=`:sa! b!!cWd> e f0ghXaL!aL!)@L!(aL!paL!W!88 aL!aL!h]K!_K!88 cL!]88 status(088  bL!status؅bL!K!xbL!1X!88 00PcL!cL!1X!hh@V!0@K!88 cL!(sR!XcL! cL!HdL!""cL!cL!hM88 @dL! dL!oK!bL!@bL!X88 9W!HfL!dL!]88 status(088  eL!status0U!L!PuR!eL!PeL!L!(dL!1X!@eL!88 00eL!XeL! 2X!hh88 fL!V!eL!V! V!fL!fL!0@K!0V!eL! fL!0@K!V!88 fL!0@W!pfL!7pdL!dL!88 hL!]88 status(088  hgL!statusK!3gL!(gL!`2X!88 `V!00hL!8gL!2X!hh88 XhL!hL! `hL!hL!0hL!xhL!psL!88 hL!hL!fL!fL!88 jL!]88 status(088  iL!statusjL!iL!2X!0@K!88 V!00XjL!jL!2X!hh0@K!88 jL!`jL! jL!PkL!0@K!jL!jL!88 HkL! kL! iL!HiL!88 sR!PmL!00]88 status0(088  lL!status( L!kL!XlL! kL!03X!88 ؅00lL!b`lL!X3X!hh88 mL!lL! V!mL!mL!L!$V!lL!(mL! 88 mL!؅xmL!xkL!kL!)88 PBK!oL!]88 status*(088  pnL!status@L!nL!@pCK!0nL!3X!88 jK!00oL!nL!3X!hhV!88 `oL! L!oL!@L!  L!hoL!pL!@L!`L!8oL!oL!cL!88 oL!oL!V!mL!mL!88 rL!8 ]88 status(088  pL!status8 qL!pL!4X!88 4O00`qL!qL!(4X!hh88 qL!@hqL!w 8@qL!XrL!qL!qL!8@88 PrL!}=?(rL!(pL!PpL!88 !>]K! @rL!@sL! {?rL!rL!88 8sL!sL![K![K!8 88 88 sL!LK!V!88 hsL!sL!88 q>sL!sL!V!88 tL!F88 a@~L!tL!^V!{ tL!uL!8tL!Fv44tL!category3W!h40uL!h(convert(int,(case when ([status] & 0x80000000 <> 0) then 2 else 0 end + case when ([replinfo] & 1 <> 0) then 32 else 0 end + case when ([replinfo] & 2 <> 0) then 64 else 0 end + case when ([replinfo] & 4 <> 0) then 256 else 0 end + case when ([xtype] = 'P' and ([status] & 2 <> 0)) then 16 else 0 end + case when ([xtype] = 'D' and ([parent_obj] <> 0)) then 2048 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 0x20 <> 0) then 1 else 0 end + case when ([status] & 0x0400 <> 0) then 4 else 0 end + case when ([status] & 0x0800 <> 0) then 8 else 0 end + case when ([status] & 0x1000 <> 0) then 128 else 0 end + case when ([status] & 0x0100 <> 0) then 512 else 0 end + case when ([status] & 0x0200 <> 0) then 1024 else 0 end + case when ([status] & 0x2000 <> 0) then 2048 else 0 end + case when ([status] & 0x4000 <> 0) then 4096 else 0 end + case when ([status] & 0x10 <> 0) then 16384 else 0 end) else 0 end)))cachesmallintV!44smallint|L!4`L!88 h}L!88 }L!|L!L!44@}L!}L!88 p}L!}L!88 }L!F44ah~L!L!{ ~L!~L!~L!4 4~L! cache L!*4L!*(convert(smallint,0)) L!4hL!sysobjectsV!0V!qX!^>V!TD4$t` Z4 ^35;=>80`;  5'0 O([base_schema_ver] & ((~15)))0 E([base_schema_ver] & 15)0(convert(char(2),case when (([xtype] = 'UQ' or [xtype] = 'PK')) then 'K' else [xtype] end))0(convert(smallint,case when (([xtype] = 'S' or [xtype] = 'U')) then 1 else 0 end))0(convert(smallint,(case [xtype] when 'S' then 1 when 'V' then 2 when 'U' then 3 when 'P' then 4 when 'RF' then 4 when 'X' then 4 when 'L' then 5 when 'D' then 6 when 'R' then 7 when 'TR' then 8 when 'PK' then 9 when 'UQ' then 9 when 'C' then 10 when 'F' then 11 when 'AP' then 13 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 1 <> 0) then 16 else 0 end + case when ([status] & 2 <> 0) then 32 else 0 end + 64 + case when (substring([name],1,1) = '#') then 256 else 0 end + case when ([status] & 0x01000000 <> 0) then 512 else 0 end + case when ([status] & 0x200000 <> 0) then 1024 else 0 end + case when ([status] & 0x04000000 <> 0) then 2048 else 0 end + case when ([status] & 4 <> 0) then 8192 else 0 end + case when (substring([name],1,2) = '##') then (-32768) else 0 end) else 0 end)))0(convert(smallint,(([base_schema_ver] & ((~15))) / 65536)))0M(convert(datetime,[crdate]))05(convert(int,0))0S(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableDeleteTrigger')) when ([xtype] = 'TR') then [parent_obj] else 0 end))0(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableInsertTrigger')) else 0 end))0(convert(int,case when (([xtype] = 'S' or [xtype] = 'U')) then (objectproperty([id],'TableUpdateTrigger')) else 0 end))05(convert(int,0))0}(convert(int,(case when ([status] & 0x80000000 <> 0) then 2 else 0 end + case when ([replinfo] & 1 <> 0) then 32 else 0 end + case when ([replinfo] & 2 <> 0) then 64 else 0 end + case when ([replinfo] & 4 <> 0) then 256 else 0 end + case when ([xtype] = 'P' and ([status] & 2 <> 0)) then 16 else 0 end + case when ([xtype] = 'D' and ([parent_obj] <> 0)) then 2048 else 0 end + case when (([xtype] = 'S' or [xtype] = 'U')) then (case when ([status] & 0x20 <> 0) then 1 else 0 end + case when ([status] & 0x0400 <> 0) then 4 else 0 end + case when ([status] & 0x0800 <> 0) then 8 else 0 end + case when ([status] & 0x1000 <> 0) then 128 else 0 end + case when ([status] & 0x0100 <> 0) then 512 else 0 end + case when ([status] & 0x0200 <> 0) then 1024 else 0 end + case when ([status] & 0x2000 <> 0) then 2048 else 0 end + case when ([status] & 0x4000 <> 0) then 4096 else 0 end + case when ([status] & 0x10 <> 0) then 16384 else 0 end) else 0 end)))0?(convert(smallint,0))0!(8000)V!0(case when ([rowcnt] > 2147483647) then 2147483647 else (convert(int,[rowcnt])) end)0(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 else 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 <> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <> 0 or (type_name([xtype]) = 'timestamp' or (type_name([xtype]) = 'char' or type_name([xtype]) = 'binary')) and [typestat] & 1 = 0)) then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end)))0(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))!0(convert(smallint,columnproperty([id],[name],'oldusertype')))0W(convert(varchar(255),[autoval]))0(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null when (type_name([xtype]) = 'uniqueidentifier') then [xprec] else (odbcprec([xtype],[length],[xprec])) end))0O(odbcscale([xtype],[xscale]))0](convert(int,sign(([colstat] & 4))))h0](convert(int,sign(([colstat] & 4))))V!K!HV!V!40\x8 | x $  ` p6nA!O8!pV!hK! V!F88 {PV!V!{ 0V!hV!V!(4P1 4XV! scaletV!:4V!:(odbcscale([xtype],[xscale]))iscomputedV!intV!88 intV!P14signV!colstatV!(044 V!colstatR!88 V!XX!V!88 V!0@K!V! F88 g88 V!rK!V!88 XV!V!88 V!V!88 V!F88 aV!xV!{ V!V!(V!44V!iscomputedH4(V!H(convert(int,sign(([colstat] & 4))))isoutparamint88 intV!4signV!pL!colstat(044 hV!colstat0@K!88 V!X!xV!88 V!pL!V!F88 g88 HV!V!p]88 V!PV!88 0qL! V!xV!88 V!F88 aV!V!{ `V!V!V!0V!4V!4V!isoutparamHV!H4V!H(convert(int,sign(([colstat] & 4))))isnullableL!int88 intV!0V!4 88 V!0@K!typestat(000 0V!typestat88 hV!X!@V!88 L!V!pV!588 88 V!0V!88 V!V!88 V!V!88 P1@V!mK!F88 aV!V!{ V!@V!hV!40@K!4(V!isnullableP1OR!J4hV!J(convert(int,(1 - ([typestat] & 1))))collationP1sysname0V!4sysnameV!4CollationPropertyFromIDcollationid(088 &V!collationidV!name 4`V!name؅8V!V!V!ЦX!*FbbP}88 V!V!4V!V!bbPV!V!88 8V!F4aV!V!{ V!8V!`V!)4hK!4 V!collationP14`V!(convert(sysname,collationpropertyfromid([collationid],'name')))tdscollationV!L1binaryP1binaryL1V!4L1CollationPropertyFromIDcollationidzۗJ(088 &V!collationid?V!uϵ>tdscollation8@w  4V! tdscollationxV!0V!V!X!FbbP}88 (V!t?V!_%8@V!0V!GbbP?V!XV!88 V!FaV!{ @V!V!V!V!40V!4hV!tdscollation4V!(convert(binary(5),collationpropertyfromid([collationid],'tdscollation')))LV!4hV!syscolumnsK!V!pX!)6/ `K! G!(8V!0V!HV!P1V!L10V!lV!P1V!L10V!V!V!V!L1 /W!0V!V!P1V!L1عL!0V!V!V!L1P1systypesusertypesmallintV!P144smallintHV!4TypePropertynamepL!(0 48V!nameV!L1P1oldusertypeP1 4V! oldusertype!L1V!@V!V!`X!V!F88 o0V!88 0V!0V!HV!V!44`V!V!8V!L188 V!`V!)88 V!V!oR!F44aK!V!oR!{ HV!V!V!r̀44pV!usertypel4V!l(convert(smallint,typeproperty([name],'oldusertype')))=K?variablebithhbit8V!8 4V!8 ]88 type_namextype(000 @V!xtypeIn@V!8 X!A1!KF4rvarbinary 4V! varbinary xV!X!Ohh varcharV!4PV!varcharV!`X!hh XV!V!O nvarchar4V!nvarchar V!X!tIhh `@V!X! ^Z NR!X!A1!KF4r(000 V!xtype S@8X!A1!KF4r(000 V!xtype!K$V@tI88 8V! W!V! @V!V!V!?V!XV!@L!88 V!V!x` Z 7n^68p8`p F8n*   K!K!  ensppc p p h_]a dlK! t0K!  K! K!K!  K!K! 4R!n  e  y4T  pV! X!   K!    K!       t y y ncK!K! K"!"#$%t&'n(r))l   t   ep0K!X! !K!"x#$%&'()            K!    y    e  c   ^t ^tX!^t^t^txu yu yuyu K!<8zu <8zu <8zu<8zu<8zuK!<8zu K!u\{u4u\{uu\{u~u|u|u|u|uax}xwx}u nx}u )x}uox}uex}u x}u t l~ut l~ux l~unY`uyY`u[Y`uiY`u)Y`uL!UuUu 5Iu5Iu 5Iu =~1u=~1uy=~1uu uu e  <8zl        v%!u!u!=~1! !! !v%Z3uZ3uZ3=~1Z3 Z3Z3Z3v%WulWuW=~1Wv%n{ uo{ u]{ 5I u u =~1 v%wuw uw =~1w v%o  x}     l  0u0u0 00X!"Uu"Uu"U "U"UuuK!usususs[yK!gugugg[y? \uo? \u? \? \[ys '-n'i '-n'r '-n'0  '-n'  '-n'  '-n'h '-n' '-n' XP8h (hx`P8x`H0pX@( h P 8  x ` 0pXhx`H0x`H0pX@pp`xH0(@XhP 88P xPhH`Ph8 pX(h@X@80( x0H`@XpH`x(= V 09n+@` t s& V! 0V!    V!  V!  4n t u) nV!`    rey  t t 4                  V! V!4d !n"a#)$y%&t'()t 4      V! V! 4!"#$%&'d()  n  a  )  y  l        l  V!            a V!    ^t ^tn^tk^t^txuyuyukyu<8zu<8zu<8zu<8zu<8zu<8zuu\{uu\{uu\{u |u|uV!|u |u|ux}xx}ux}ux}ux}ux}ux}u l~u  l~u l~uY`uY`uY`uY`uY`uV!Uu Uu5Iu5Iu5Iu=~1u=~1u=~1uuuu  <8zX!       v%!u!uV"!=~1! !!!v%Z3uZ3uZ3=~1Z3 V!Z3V!Z3Z3v%WuWuW=~1Wv%{ uy{ u{ 5I u ut =~1n v%lw utw u(w =~1rw v%t o x}1 ) y  l  0u0ul0 V!00"Uu"Uu"U "U"UuuauV!sususs[ygugungkg[y? \u? \u? \? \[yk '-n' '-n' '-n' '-n' '-n' '-n' '-n' '-n'88 `TV!8TV!TV!88 hTV!F|_TV! X!F4tj88 0UV!RV!TV!8UV!4UV!`UV!88 UV!FaUV!88 (VV!VV!UV!UV!HX!Fa88 VV!RV!44XVV!VV!VV!VV!88 WV!F44a0^V!xWV!{ WV!WV!(WV!4 4WV! fkey24 XV!(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))fkey3smallint44smallintXV!4isnullbinarybinaryYV!4reversesubstringforkeys(0 ZV!forkeysHZV! 88 ZV!ZV!ZV!88 88 @[V![V!ZV!88 H[V!F|_p[V!pX!F4tj88 \V!YV![V!\V!4[V!@\V!88 h\V!Fa\V!88 ]V!\V!\V!\V!X!Fa88 ]V!`pP0@  p ` @ P 0  P ` p  p0@P` p 0@P`p0@`P P`p@ 0p`0@P    p ` Pp @` 0P @ 0          p ` Pp @` 0P @ 0    P@0p` @ 0 p ` P  @ 0   p`P@0 p`P@p0`P@ 0 pp``PP@@0 0 p` Z :^98W!`5=X p;F0?(convert(smallint,0))0!(8000)i0(case when ([rowcnt] > 2147483647) then 2147483647 else (convert(int,[rowcnt])) end)0(convert(tinyint,(([bitpos] & 7) + case when ([typestat] & 1 = 0) then 8 else 0 end + case when (([typestat] & 2 <> 0 or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x1000 <> 0)) then 16 else 0 end + case when (((type_name([xtype]) = 'image' or type_name([xtype]) = 'text') and [colstat] & 0x2000 <> 0 or (type_name([xtype]) = 'timestamp' or (type_name([xtype]) = 'char' or type_name([xtype]) = 'binary')) and [typestat] & 1 = 0)) then 32 else 0 end + case when ([colstat] & 4 <> 0) then 64 else 0 end + case when ([colstat] & 1 <> 0) then 128 else 0 end)))0(convert(tinyint,xtypetotds([xtype],(1 - ([typestat] & 1)))))0(convert(smallint,columnproperty([id],[name],'oldusertype')))0W(convert(varchar(255),[autoval]))0(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null when (type_name([xtype]) = 'uniqueidentifier') then [xprec] else (odbcprec([xtype],[length],[xprec])) end))!0O(odbcscale([xtype],[xscale]))0](convert(int,sign(([colstat] & 4))))0](convert(int,sign(([colstat] & 4))))0_(convert(int,(1 - ([typestat] & 1))))0(convert(sysname,collationpropertyfromid([collationid],'name')))0 (convert(binary(5),collationpropertyfromid([collationid],'tdscollation')))0 (convert(smallint,typeproperty([name],'oldusertype')))LW!0A(convert(bit,case when ((type_name([xtype]) = 'nvarchar' or (type_name([xtype]) = 'varchar' or type_name([xtype]) = 'varbinary'))) then 1 else 0 end))0[(convert(bit,(1 - ([status] & 1))))0e(convert(tinyint,xtypetotds([xtype],0)))u0M(convert(varchar(255),null))0(convert(smallint,case when ((type_name([xtype]) = 'ntext' or (type_name([xtype]) = 'image' or type_name([xtype]) = 'text'))) then null else (typeproperty([name],'precision')) end))0s(convert(tinyint,typeproperty([name],'scale')))0(convert(sysname,collationpropertyfromid([collationid],'name')))0m(convert(smallint,(2 + 4 * ([status] & 1))))0?(convert(smallint,0))0O(convert(bit,([status] & 1)))0 O(convert(bit,([status] & 2)))!0 (convert(nvarchar(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))u0 ?(convert(smallint,0))0 ?(convert(smallint,0))0 O(convert(bit,([status] & 2)))0 O(convert(bit,([status] & 4)))0 O(convert(bit,([status] & 8)))0?(convert(smallint,0))0 ?(convert(smallint,0))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],1,2))),0)))VW!0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))WW!0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))YW!0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],11,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],13,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],15,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],17,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],19,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2))),0)))!0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],25,2))),0)))h88 _W!(0 h_W!@_W!д<L\dt4x80<( `  \ X8`-.J9<.6@0.   Crefmod0. 44  =uid0. 44  Cstatus0.  ?name0. U  =sidaV!0.   Aroles0. ==  Kcreatedate0. ==  Kupdatedate0. 44  Caltuid0.   Gpassword0. 88   ;id0. 44  EsmallidjV!0. 00   ?type0.   ?name0. bbP  Avalue0. 88  < ;id0. 88  < Adepidg0. 44  < Cnumber0. 44 < Idepnumbert0. 44 < Cstatus0. 00 < Edeptype0. 44 Edepdbid0. 44 Idepsiteid0. hh   Cselall0. hh   Iresultobj 0. hh   Ereadobj0.88  Econstid0.88  Cfkeyid0.88    Crkeyid0.44 Irkeyindid0.44 Ckeycnt0.  Eforkeys0.  Erefkeys0.44 Gfkeydbid0.44   Grkeydbid0.44   Afkey1iV!0.44   Afkey20.44   Afkey30.44   Afkey40.44 Afkey540.44 Afkey6n0.44 Afkey7[0.44 Afkey8l0.44 Afkey9i0.44 Eftcatid0.4?name0.44 Cstatus0.4?path0.88 G+ Etableid0.44G+ Erowinfo0.G+ Aftkey80.`44 EgroupidnV!0.`44 MallocpolicynV!0.`88  Cstatus0.`4Igroupname0.44 Cfkey10!0.44 Cfkey110.44 Cfkey120.44 Cfkey13!0.44 Cfkey140.44 Cfkey150.44 Cfkey160.44 Arkey1qV!0.44 Arkey20.44 Arkey350.44 Arkey4a0.44 Arkey5v0.44 Arkey600.44   Arkey740.44!! Arkey80.44"" Arkey9y0.44## Crkey10!0.44$$ Crkey110.44%% Crkey120.44&& Crkey13!0.44'' Crkey140.44(( Crkey150.44)) Crkey160. 44   =gid0.   Eenviron0. 88    Mhasdbaccess0. 88   Eislogin0. 88  Gisntname0. 88  Iisntgroup0. 88  Gisntuser0. 88  Iissqluser0. 88  Iisaliased0. 88  Iissqlrole0. 88  Iisapprole0.88  ;id0.44 Aindids0.44  Acolidr0.44   Akeyno)0.88  Econstid40.88  Cfkeyid0.88    Crkeyid0.44 ?fkey0.44 ?rkey0.44 Akeyno0.44 Imemberuid{V!0.44 Ggroupuid!0.88  ;id0.44 =uid 0.00  Caction0.00   Mprotecttype0. Ecolumns0.44   Egrantor0._44 Cfileid0._44 Egroupid0._88  ?size0._88    Emaxsize0._88  Cgrowth0._88  Cstatusa0FL!8V!{l$x0d P @|0l(X D $XH|8l(\L x 4 h $ P  |0`<hXLHd@h8h(`;> , =]10O(convert(bit,([status] & 1)))0 O(convert(bit,([status] & 2)))0 (convert(nvarchar(4000),case when ([status] & 2 = 2) then (uncompress([ctext])) else [ctext] end))0 ?(convert(smallint,0))0 ?(convert(smallint,0))0 O(convert(bit,([status] & 2)))0 O(convert(bit,([status] & 4)))!0 O(convert(bit,([status] & 8)))!0?(convert(smallint,0))0 ?(convert(smallint,0))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],1,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],3,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],5,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],7,2))),0)))40(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],9,2))),0)))g0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],11,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],13,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],15,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],17,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],19,2))),0)))!0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],21,2))),0)))0 (convert(smallint,case when ([uid] >= 16400) then [uid] when ((datalength([roles]) is null or datalength([roles]) <= 2)) then 0 else (16384 - 8 + datalength([roles]) * 8 + case when (convert(tinyint,[roles]) & 1 <> 0) then 0 when (convert(tinyint,[roles]) & 2 <> 0) then 1 when (convert(tinyint,[roles]) & 4 <> 0) then 2 when (convert(tinyint,[roles]) & 8 <> 0) then 3 when (convert(tinyint,[roles]) & 16 <> 0) then 4 when (convert(tinyint,[roles]) & 32 <> 0) then 5 when (convert(tinyint,[roles]) & 64 <> 0) then 6 when (convert(tinyint,[roles]) & 128 <> 0) then 7 end) end))ll0 M(convert(varchar(255),null))ub0 (convert(int,case when ([status] & 2 = 2) then 1 else 0 end))t0 (convert(int,case when ([status] & 32 = 0 and [uid] > 0 and ([uid] < 16384)) then 1 else 0 end))ev0 (convert(int,case when ([status] & 4 = 4) then 1 else 0 end))l0 (convert(int,case when ([status] & 12 = 4) then 1 else 0 end))on0 (convert(int,case when ([status] & 12 = 12) then 1 else 0 end)))0 (convert(int,case when ([status] & 60 = 0 and [uid] > 0 and ([uid] < 16384)) then 1 else 0 end))0 (convert(int,case when ([status] & 16 = 16) then 1 else 0 end))10 (convert(int,case when (([uid] >= 16384 or [uid] = 0)) then 1 else 0 end))re0 (convert(int,case when ([status] & 32 = 32) then 1 else 0 end))rverse(substring([refkeys],19,2))),0)))0$(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))0%(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))0&(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))0'(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0((convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],31,2))),0))) 4h[L! rkey5xsK!4[L!(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],9,2))),0))) W!rkey6 V!smallint]L!44smallintp\L!4p)!isnullbinary@L!binary]L!0@L!4reversesubstringrefkeys(0 ^L!refkeys]L! 88 h^L! @^L!^L!@L!88 `@88 ^L!,?^L!p^L!88 `@^L!tIF|_^L!n@$Y!0@L!F4tjt_L!88 _L!_L!]L!L1\(l$ h 4xDL\TT0Xx `=~>0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],23,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],25,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],27,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],29,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([forkeys],31,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],1,2))),0)))n0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],3,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(qubstring([refkeys],5,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],7,2))),0)))0(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],9,2))),0)))0(convert(smallint,isnull(aonvert(binary(2),reverse(substring([refkeys],11,2))),0)))0 (convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],13,2))),0)))0!(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],15,2))),0)))0"(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],17,2))),0)))!0#(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],19,2))),0)))0$(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],21,2))),0)))0%(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],23,2))),0)))0&(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],25,2))),0)))0'(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],27,2))),0)))0((convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],29,2))),0)))0)(convert(smallint,isnull(convert(binary(2),reverse(substring([refkeys],31,2))),0)))0:sCREATE VIEW syssegments (segmemt, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 0^tCREATE VIEW sysconstraints AS SELECT constid = convert(int, id), id = convert(int, parent_obj), colid = convert(smallint, info), spare1 = convert(tinyint, 0), status = convert(int, CASE xtype WHEN 'PK' THEN 1 WHEN 'UQ' THEN 2 WHEN 'F' THEN 3 WHEN 'C' THEN 4 WHEN 'D' THEN 5 ELSE 0 END + CASE WHEN info != 0 -- CNST_COLUMN / CNST_TABLE THEN (16) ELSE (32) END + CASE WHEN (status & 16)!=0 -- CNST_CLINDEX THEN (512) ELSE 0 END + CASE WHEN (status & 32)!=0 -- CNST_NCLINDEX THEN (1024) ELSE 0 END + (2048) -- CNST_NOTDEFERRABLE + CASE WHEN (status & 256)!=0 -- CNST_DISABLE THEN (16384) ELSE 0 END + CASE WHEN (status & 512)!=0 -- CNST_ENABLE THEN (32767) ELSE 0 END + CASE WHEN (status & 4)!=0 -- CNST_NONAME THEN (131072) ELSE 0 END + CASE WHEN (status & 1)!=0 -- CNST_NEW THEN (1048576) ELSE 0 END + CASE WHEN (status & 1024)!=0 -- CNST_REPL THEN (2097152) ELSE 0 END), actions = convert(int, 4096), error = convert(int, 0) FROM sysobjects WHERE xtype in ('C', 'F', 'PK', 'UQ', 'D') AND (status & 64) = 0 0˿w(0)0x/* ** Generate an ansi name that is unique in the dtproperties.value column */ create procedure dbo.dt_generateansiname(@name varchar(255) output) as declare @prologue varchar(20) declare Aindexstring varchar(20) declare @index integer set @prologue = 'MSDT-A-' set @index = 1 while 1 = 1 begin set @indexstring = cast(@index as varchar(20)) set @name = @prologue + @indexstring if not exists (select value from dtproperties where value = @name) break set @index = @index + 1 if (@index = 10000) goto TooMany end Leave: return TooMany: set @name = 'DIAGRAM' goto Leave e0y/* ** Add an objeat to the dtproperties table */ create procedure dbo.dt_adduserobject as set nocount on /* ** Create the user object if it does not exist already */ begin transaction insert dbo.dtproperties (property) VALUES ('DtgSchemaOBJECT') update dbo.dtproperties set objectid=@@identity where id=@@identity and property='DtgSchemaOBJECT' commit return @@identity 0<8z/* ** If the property already exists, reset the value; otherwise add property ** id -- the id in sysobjects of the object ** property -- the name of the property ** value -- the text value of the property ** lvalue -- the binary value of the property (image) */ create procedure dbo.dt_setpropertybyid @id int, @property varchar(64), @value varchar(255), @lvalue image as set nocount on declare @uvalue nvarchar(255) set @uvalue = convert(nvarchar(255), @value) if exists (select * from dbo.dtproperties where objectid=@id and property=@property) begin -- -- bump the version!count for this row as we update it -- update dbo.dtproperties set value=@value, uvalue=@uvalue, lvalue=@lvalue, version=version+1 where objectid=@id and property=@property end else begin -- -- version count is auto-set to 0 on initial insert -- insert dbo.dtproperties (property, objectid, value, uvalue, lvalue) values (@property, @id, @value, @uvalue, @lvalue) end 0u\{/* ** Retrieve the owner object(s) of a given property */ create procedure dbo.dt_getobjwithprop @property varchar(30), @value varchar(255) as set nocount on if (@property is null) or (@property = '') begin raiserror('Must specify a property name.',-1,-1) return (1) end if (@value is null) select objectid id from dbo.dtproperties where property=@property else select objectid id from dbo.dtproperties where property=@property and value=@value W!inaryW! |T d 0 t@ P` t?IY!44qp Y!4 Y!P! Y!I Y! Y!8CE!q Y!4 Y!`P! Y!I Y!!Y!@!Y!q!Y!4 !Y!@P!0!Y!I@!Y!P!Y!q`!Y!4p!Y! P!!Y!I!Y! !Y!!Y!q!Y!4!Y!]@bV!!Y!I!Y!!Y!q"Y!4"Y! iV! "Y!I0"Y!#Y!@"Y!qP"Y!4`"Y!pV!p"Y!I"Y!"Y!q"Y!4"Y! vV!"Y!I"Y! "Y!q"Y!4#Y!#Y!}V!#Y!I #Y! 0#Y!q@#Y!4P#Y!DL!`#Y!Ip#Y!E#Y!q#Y!4#Y!KL!#Y!I#Y!#Y!q#Y!W!$Y!'Y!I$Y!XL!q($Y!4@$Y!IX$Y!^L!p$Y!q4$Y!W!$Y!I$Y!$Y!$Y!q$Y!%Y!xW!$Y!I%Y!%Y!W!88q%Y!40%Y!88IH%Y!ȓW!`%Y!q4x%Y!8W!88I%Y!%Y!q%Y!W!%Y!I%Y!ȡW!q&Y!4 &Y!h&Y!I8&Y!W!P&Y!q4h&Y!W!I&Y! &Y!q&Y!W!&Y!I&Y! hW!'Y!q&Y!4'Y!I('Y! HW!@'Y!q4X'Y!W!'Y!Ip'Y!'Y!q'Y!W!0X!#Y!'Y!0X!(X!(Y!8+Y!(Y!H(Y!(Y!(Y!(Y!(,Y!()Y!,Y!`)Y!)Y!)Y!*Y!@*Y!,Y! +Y!0X!40W!X+Y!0X!88 *Y!0X!88 +Y!0X!4x*Y!0X!40W!*Y!0X!88 ]W!W!,Y!XW!-Y!W!X!X! X!(X!PX!X!"X!W!x,Y! W!x,Y! W!hE!  8,Y! W! E88 HW!88 .Y!0X!*Y! H W!,Y!0X!+Y!-Y!,Y!.Y! @-Y!0X!3Y!-Y!@-Y!H.Y!E.Y!0X!3Y!E4.Y!.Y!H.Y!-Y!0X!*Y!xtE88 P/Y!0X!+Y!.Y!P/Y!.Y!`/Y!xW!H.Y!0X! +Y!0W! /Y!0X!X+Y!E/Y!/Y!H,Y!0X!+Y!E88 0Y! 3Y!W!E W! 0Y!  W!E@0Y! W!`0Y!E88 H0Y!0Y!0Y! W!0Y!0Y! @W! 0Y! W!0Y!E88 0Y!W!E1Y! HPW! 1Y!D44H@1Y!44 W!`1Y!E88 1Y!X!E88 1Y!X! 1Y!E88 1Y! XX!aE88 2Y!H p X!  2Y! X!88E88 @2Y!@ X!E`2Y! HPX!2Y!2Y!  X!2Y!2Y! 2Y!X!st  2Y!E88 2Y! X!E88 3Y!H X!D 3Y!HX!@3Y! F X!E`3Y! X!3Y!E88 H3Y!3Y!  X!3Y!0X!hh%8Y!X!D44Hx X!tu `X!E88  H X!nE88 H 4Y!id4Y!q445Y!TableDeleteTriggerX5Y!6Y!(ip5Y!E! 5Y!06Y! 5Y!6Y!hh@(0 4 5Y!xtype4(6Y!SH6Y! p6Y!6Y!88hh(0 4 6Y!xtype46Y!U7Y!p7Y!st(088 X7Y!parent_obj7Y!X8Y!7Y! 7Y!(8Y!hhan(0 4 8Y!xtype4P8Y!TR8Y!88 8Y!8Y!88 88 =Y!H9Y!(i488 p9Y!isF88 a9Y!9Y!88 88 9Y!9Y!0=Y!88 :Y!lr]88 @:Y!;Y!88h:Y!:Y!E!F88 n(088 :Y!id:Y!q44;Y!TableInsertTrigger@;Y!!@3l4m 0?3db_accessadmin0?9db_backupoperator0?1db_datareader0?1db_datawriter0?-db_ddladmin0?9db_denydatareader0?9db_denydatawriter0?'db_owner0?7db_securityadmin0?dbo0?!guest0?#publicTl,%{${{p?{YzTm3O@@ @؄{MTZO@5@ @%{MT[kO@8@ @%{MT)O @~@ @/y{MTO@@ @ %dt_vcsenabled&w +dt_whocheckedout& 9dt_addtosourcecontrol_u&0/dt_checkinobject_u&"U1dt_checkoutobject_u&[y1dt_displayoaerror_u&?dt_getpropertiesbyid_vcs_u&s=dt_isundersourcecontrol_u&g;dt_validateloginparams_u&? \/dt_whoaheckedout_u*x.PELEVE*RDPK_ELEVE*v8VEHICULE*#,!PK_VEHICULE*\ LECON*Tmp_LECON*LECON* PK_LECON*,-FK_LECON_VEHICULE*@P'FK_LECON_ELEVE*yt#Tmp_VEHICULE*ytVEHICULE*!PK_VEHICULE*-FK_LECON_VEHICULE*$ Tmp_ELEVE*$ ELEVE*]!PK_ELEVE*)"'FK_LECON_ELEVE*M#Tmp_LECON*M#LECON*r$PK_LECON*A%-FK_LECON_VEHICULE*zz&'FK_LECON_ELEVE*n'Tmp_ELEVE&n'ELEVE&c(PK_ELEVE*%'W)Tmp_LECON&%'W)LECON&^KK*PK_LECON*o?+-FK_LECON_VEHICULE&Г3,'FK_LECON]ELEVE& '-%pEleve_INSERT*B.#Tmp_VEHICULE*B.VEHICULE*{/!PK_VEHICULE*$0-FK_LECON_VEHICULE*H07DF_VEHICULE_voitureO/N*&m1#Tmp_VEHICULE&_27DF_VEHICULE_voitureO/N&&m1VEHICULE&3!PK_VEHICULE&4-FK_LECON_VEHICULE\\< `@ xP0`x D |   , X , Pl P, LX $X$ ZL.P^K8` @ M     _u`:s^tuuXvu˿wxy<8zu\{c|ax} l~Y`U5IZ==~1v% !Z3W{  > w  0"Uu[yvsvgv? \v x.Pv x.PRDv v8 v8#, \     , @P yt yt  $ $ ]! )" M# M#r$ M#A% M#zz&n'n'c(%'W)%'W)^KK* %'U)o?+%'W)Г3, '- B. B.{/ %'W)$0 B.H0&m1&m1_2&m13%'W)4ttttthh\t\PDP|pdXL@4(8, xl` ZN.m^M8`OIfwV?1 C=AA@@ATfOOO Ow{MTg@OO O<{{MiwVى=ى=ى=AA@`A*?Ti~&;Pez?"?#?$?0?4?8?:???<?=?>?b?c?h?j?l?z?????????Tj:@OO O<{{MTk8Z8%{${Hiz|?kz} {AmȜwV??dA?`A@0?%PRIMARYTOY"&%I>%I>d$IA@ITA@$Gl0?$DtgDSRefBYTES0?#DtgDSRefDATA0?%DtgSchemaBYTES0?$DtgSchemaDATA0?$DtgSchemaGUID0?$DtgSchemaNAME0?&DtgSchemaOBJECTTY OO3O O%{MZ"&L>%I>%I>:۶B@@@%IrA@ITAc0?c{EA3E6268-D998-11CE-9454-00AA00A3F36E}0?4560?87040?'DIAGRAM1y["&?%I>%I>$IA@@@ITA@TOCO OI{MTOWO O+{MT!OaO O>d AA A:Wt?123POI93 ?1245GH93 ?4411FG93 ?456AZE93 ?488GFT93 ?4896YT93 ?6987IL93 ?7899ER93 TO OO OK{MD+ ?9=d0AA? A@@T6O OO O.=dA0A B A:W@123POI93 @1245GH93 @4411FG93 @@456AZE93 TOsOO OX5!{MTsOO O`3!{MT6sOO OT2!{M@@T6O OO O>5 .floatt0"" .image&088  *inty0<< .money0@ .nchar0cc .ntexti0ll&& 2numericr0@ 4nvarchar0;; ,real0:: >smalldatetimer044 4smallint0zz  8smallmoney0bbP :sql_variant0 2sysname0## ,text0 6timestampa000 2tinyint&0$$ Duniqueidentifier0@ 6varbinary0@ 2varcharrkeys&name&statblob&maxlen&rows&name&id&xtype&typestat&xusertype&length&xprec&xscale& colid& xoffset& bitpos& reserved& colstat&cdefault&domain&number&colorder&autoval&offset&#collationid&language&status&type&usertype&printfmt&prec&scale&!iscomputed&!isoutparam&!isnullable&collation& %tdscollation&name&xtype&status&xusertype&length&xprec&xscale&tdefault& domain& uid& reserved& #collationid& usertype&variable&!allownulls&type&printfmt&prec&scale&collation&id&number&colid&status&ctext&texttype&language&encrypted& !compressed& text&status&fileid&name&filename& id& grantee& grantor& actadd& actmod& seladd& selmod& updadd& updmod& refadd& refmod& uid& status& name& sid& roles& !createdate& !updatedate& altuid& password& gid& environ& #hasdbaccess& islogin& isntname& isntgroup& isntuser& issqluser& isaliased& issqlrole& iqapprole& id& smallid& type& name& value& id& depid& number& depnumber& status& deptype& depdbid& depsiteid& selall& resultobj& readobj&constid&fkeyid&rkeyid&rkeyindid&keycnt&forkeys&refkeys&fkeydbid& rkeydbid& fkey1& fkey2& fkey3& fkey4&fkey5&fkey6&fkey7&fkey8&fkey9&fkey10&fkey11&fkey12&fkey13&fkey14&fkey15&fkey16&rkey1&rkey2&rkey3&rkey4&rkey5&rkey6& rkey7&!rkey8&"rkey9&#rkey10&$rkey11&%rkey12&&rkey13&'rkey14&(rkey15&)rkey16&ftcatid&name&status&path&id&indid&colid&keyno&constid&fkeyid&rkeyid&fkey&rkey&keyno&memberuid&groupuid&id&uid&action&#protecttype&columns&grantor&tableid&rowinfo&ftkey&_fileid&_groupid&_size&_maxsize&_growth&_status&_perf&_name&_ filename&`groupid&`#allocpolicy&`status&`groupname&:ssegment&:sname&:sstatus&^tconstid&^tid&^tcolid&^tspare1&^tstatus&^tactions&^terrorr]B# lS8#lI0 v]B+u\C*lU>'zaJ3uX=" cJ+|eP; vW:wV?, n U < #  x c B #  x Y B -  } ` M 4   j E &  z]H/lO4dG0 xYB%eF'vaJ3`(xLp0l< L` ZSn0^RT8`xTn2(&Rbigint w why w w+@y !w !wy&!w'!w!yG!wH!wy`!wa!wy{!w|!w!y!w!w-xy!w!wHy!w!wy!w!w8y"w"w`y3"w4"wyN"wO"w0yi"wj"wy"w"wy"w"wPy"w"w y"w"wy"w"w(y #w #wPy#w#wy3#w4#w8yJ#wK#wya#wb#w`yv#ww#wy#w#wy#w#wXy#w#wy#w#w y#w#wy$w$wxy'$w($wyF$wG$wye$wf$wy$w$wy$w$wy$w$w)y$w$w#Hy%w%wy%%w&%wyB%wC%wyY%wZ%wyx%wy%w0y%w%why%w%wy%w%wpy%w%wy%w%wy &w &wxy&w &wy0&w1&wpyG&wH&w8yd&we&w` y&w&wy&w&wy&w&w@y&w&wy&w&wy&w&wHy'w'wy4'w5'w`yO'wP'wyl'wm'w(y'w'wy'w'w0y'w'wy'w'why'w'w#y(w(wy/(w0(wyH(wI(wXy](w^(wyz(w{(wy(w(wPy(w(wy(w(w!y(w(w!y)w)w!y&)w')wyE)wF)w% yj)wk)w y)w)wXy)w)wy)w)w y)w)wy)w)wy)w)w(y*w*wx y4*w5*wpyM*wN*w0 y`*wa*w y}*w~*w#y*w*wH y*w*wy*w*w! y*w*wy+w+w y-+w.+w yB+wC+w@yY+wZ+w yx+wy+w y+w+w8 y+w+w y+w+w y+w+w y+w+w y,w,w y#,w$,w yB,wC,w!P yc,wd,wh yx,wy,w y,w,w( y,w,w y,w,w y ,w,w y ,w,wp y -w -w@ y #-w$-w y <-w=-wX y U-wV-w y n-wo-w y -w-w y -w-w y -w-w0 y -w-w y -w-w y -w-wH y .w.w y ,.w-.w` y ?.w@.w y V.wW.w!8 y w.wx.w!(y .w.w y .w.w y .w.wP y .w.w y .w.w# y /w /w y :/w;/w y W/wX/w y v/ww/w y /w/wx y /w/wy /w/w y /w/wh y 0w0wpy 0w!0wXy ;0w<0wy P0wQ0w@y e0wf0w0y |0w}0wy 0w0wy 0w0wy 0w0wHy 0w0wy 0w0wy 1w1wy +1w,1wy J1wK1wy c1wd1w`y 1w1wxy1w1wy1w1w y1w1wy1w1wy 2w 2w8y"2w#2wy=2w>2wyX2wY2wyu2wv2wy2w2wXy2w2wy2w2wy2w2wy2w2wy3w3wy3w3w(y33w43w@yJ3wK3wPya3wb3wpyz3w{3wy3w3wy3w3wy3w3wy3w3wy3w3wy4w4wy'4w(4w0y>4w?4wHyU4wV4w`yl4wm4wxy4w4wy4w4wy4w4wy4w4why4w4wy4w4wy5w5w y*5w+5w8yC5wD5wPy\5w]5whyu5wv5wy5w5wy5w5wy5w5wy5w5wy5w5wy5w5w(y6w6wy+6w,6w@yB6wC6wy]6w^6wyv6ww6wy6w6wXy6w6wpy6w6wy6w6w0y6w6wy 7w 7wHy7w7wy07w17w`yI7wJ7w#yl7wm7wxy7w7wy7w7wy7w7wy7w7wy_7w7wy_8w 8w8y_#8w$8wPy_88w98wy_S8wT8w y_l8wm8wy_8w8wy_8w8why_8w8wy`8w8wy`8w8w#y` 9w 9w(y`#9w$9wy:sB9wC9w@y:s]9w^9wy:sr9ws9wy^t9w9wy^t9w9wy^t9w9wXy^t9w9wy^t9w9w^t:w:wy^t:w:wpyhyyhyp(yyyp(xyyxyp(yyyp(y(y xp( {ri`U&"image&#text&$'uniqueidentifier&0tinyint&4smallint&8 int&:!smalldatetime&;real&<moneyz&=datetime&>float&bsql_variant&cntext&h bit&jdecimal&lnumeric&zsmallmoney&bigint&varbinary&varchar&binary&char&timestamp&nvarchar&nchar&sysnamezzp(zXzzp(@zz@zp(ȥzhzȨzp(PzzPzp(بzxzثzp(`zz`zp(zzzp(pzzpzp(zzzp(z zzp(zzzp(z0zzp(zzzp(z@zzp((zؼz(z8zp(z`zzzzp(8z z8z8zHzp(varcharzzzzпzp(varbinaryHzx\L8 `L4 t` ZV^U8` `W6@&db_accessadmin6@,db_backupoperator6@$db_datareader6@$db_datawriter6@ db_ddladmin6@,db_denydatareader6 @,db_denydatawriter6@db_owner6@*db_securityadmin:dbo6guest6public:.dbo7B@{s4C 26.dbo7B@{s4C 20tH` Z X^W8``xY=&PRIMARY` Z`Z;^Y8` Zu[^2\8Y`u\E 2008&DtgSchemaOBJECT0 (NDtgSchemaGUID{EA3E6268-D998-11CE-9454-00AA00A3F36E}{EA3E6268-D998-11CE-9454-00AA00A3F36E}0 (0@DtgSchemaNAMEDIAGRAM1DIAGRAM10 (+1DtgDSRefBYTES4564560)))9DtgDSRefDATA]0 )-5DtgSchemaBYTES870487040***:DtgSchemaDATA]0*-3CDtgDSRefBYTES456456]0+/7GDtgSchemaBYTES87048704]@X0G] uoY0F0Y`] ]F0Y oY]`oYoYmYlY@lY]]0YK0YY0YcYK0YY0YcY]Xa]@]]X!]88 H(0Y`]&_88|]]`]H(0YxY]R@]8]]H(0Y@]+_@,]H]@]X X!]H(0YzY ]]]]H(0YX]X ]p\H(0Y{Y ]]H(0Y {YYX]]]H(0Y]hY\\H(0Y]x]<]P]\H(0Y@{Y@]8H(0Y`{YY]]8 s]8:0Y88 8\xDD0YxDD0YxDD0YxDD0YD͘0YxDD0YxDD0YxDD0YxDD0YxDD0YxDD0Y`<0Y88 V\ ]88 \?0Yll&:0Y `\X]0\?0Yll&`<0Yll&lYp`]]@]]]]]0]]h\\\x\0\`\\\\\H\p\\\ \x\0\\\]r_F)?Q%;)?Q%;)? ]?ư>x(?5|?8m!#{?Q%;)?謹>p]o^o^??@IH\`]88 88  oYI0\]88 88  nYư>I \@lY""""nY]`HFH>_r^n^]pFYHFH>_`s^]pFHF1_ i:H]]pFHF] i:]]pFHF] i:]]pFHF]m>@]]pFHF;_]@]pF|HvYeY0YbY0YbY0YbY|H @wYfY0Y@cY0Y0cY0Y cY \]""oY""] ]H]p(D0YGp(D0Yp(D0Y0YH]0Yll&o^oYb3h%?0Y( jY0Y(@hYGxDD0YxDD0YxDD0Y]a0Y>>5fY>oYb3h%?0Y(iY0Y(hYh]0Y>>5fYoYb3h%?0Y(`]0Y(]](H]]@]h]]]]]0]X]]]a0Yd0YY]??@`Ș0Y88 `Ș0Y88 XT0Y`]c^@c^`c^c^c^c^c^ ]˘\ ^u^8Y]]]]] ]@]`]]ɘ0Y`HwYvYvYvYvYnY`H wYwYxwYpwYhwYoY] ]]_xYB] 10Yhh^oYBoY`oYoY]mYlYB@lY]]oY]@`oYoY]mYlY@lYA]]oY]`oYoY]0mY]lY@lY]]( nYmY|9 `u]E QW9Ѕ$nHDRIVER=SQL Server;SERVER=(LOCAL);Trusted_Connection=Yes;APP=MS SQLEM - Data Tools;WSID=PATRICE;DATABASE=ecoleConduite;AutoTranslate=YesDIAGRAM1& ELEVEdbo& LECONdbo$VEHICULEdboT] ܯt)(@,,{M~Tools;WSID=PATRICE;DATABASE=ecoleConduite;AutoTranslate=YesDIAGRAM1& ELEVEdbo& LECONdbo$VEHICULEdbo T_"]ܯt)(@,,{MTTion=Yes;APP=MS SQLEM - Data Tool~Tools;WSID=PATRICE;DATABASE=ecoleConduite;AutoTranslate=YesDIAGRAM1& ELEVEdbo& LECONdbo$VEHICULEdbo @,_(,_H,_0,_hd^pi^j^k^o^h,_LD5{EA3E6268-D998-11CE-9454-00AA00A3F36E}pD0Y,_tDLpD0Y,_tDLpDB0Y-_tDLpD0Y<-_tDLpD0Y`-_tDLpD0Y-_tDLpD0Y-_tDLpD@0Y-_tDLpD0Y-_tDLpD0Y._tDLpD0Y8._tDLpD0Y\._tDLpD"dateXw^pD }^._ pDi] ._0s]._pD s]._ pDxv] /_v]pD 0s]@/_4/_ pDs]`bY X/_xv]pD 0s]/_|/_ pDs] /_DL D0Y/_tDLpDnB0Y/_tDLpD0Y 0_tDLpD0Y00_tDLpD]0YT0_tDLpD0Yx0_tDLpD_0Y0_tDLpD0Y0_tDLpD0Y0_tDLpDd0Y1_tDLpD0Y,1_tD]pDnB0YP1_tDLpD0Yt1_tDLpD0Y1_tDLpDiP]0Y1_tDLpD0Y1_tDLpDnBD??@]@]]r^xDD0YxDD0YG]0Y0ExDD0YP~]H3_ ~] DxYFxDD0YxDD0Y0]0H,_?_p(D0Yp(D0Yp(D0Yp]]D0YH]0@*_?_'`]hp(??@]@]]Ȏ]`]x^D0Yp(D0YG]0Y00hp(??@]@]]]`]idobjectidpropertyvalueuvalue0Ylvalueversion]0Y0p(p(D0Yp(D0Yp(D0Y9_9_488 @8_id448_ 88 9_u 9_`9_0Y8_9_8_D89_F88 0:_488  @ :_version88 X:_8]x]p(D0Y p(D0YG]+`0YD??@ ]@]]P]x]xDD0Y xDD0Y^0Y0ExDD0YxDD0YxDD0YxDidDobjectidpropertyvalueuvaluelvalueversionD??@gY@]]xDD0YxDD0YG0YD??@]@]o^xDD0YxDD0YG]0Y00$<8/R'88 u^00$<Ж]  0@$<8/R)$88 j6` Zu^ ^]_8@c]`u_E ࡱ>   Root EntryЅ$nfo " CompObj0a  !"#$%&'()*+,-./13456789:;<=>?@ABCDEFGHIJKLMNOPQTUVWXYZ0    }P,$m7ހ[\0<k QW9pNFCZOaO=Oy1(CSDMc`H虅P`$(CQDMc`Hk\0` R8Control4.*jRelation 'FK_LECON_VEHICULE' entre 'VEHICULE' et 'LECON'\ R2Control8jRelation 'FJ_LECON_ELEVE' entre 'ELEVE' et 'LECON'LE, 1UDDSLabel5*E, 1ODDSLabel9E0 SchGrid1ELEVEid10 SchGrid37VEHICULE0 SchGrid2LECONid2 7Z+p'*E 2 'E 2 DBTajomaFK_LECON_VEHICULE DBTahomaFK_LECON_ELEVE!C4xV4ELEVEE`T,,,4s#T- rFX eerrr%J rxV4T  dboELEVE!C4h xV4VEHICULE`T,,,4s#^- rFX eeh rh rr%J rxV4Z  dbo VEHICULE!C4^xV4LECON`T,,,4s#- rFX ee^r^rr%J rxV4T  dboLECON Microsoft Forms 2.0 FormEmbedded Object9q &sch_labels_visible d0u(ActiveTableViewMode1 TableViewMode:0D5,0,284,0,1650,1,1350,2,600,5,900 TableViewMode:12,0,284,0,165DdsStream2Schema UDV Default&RDSREF-SCHEMA-CONTENTS,SSchema UDV Default Post V66[0 TableViewMode:22,0,284,0,1650 TableViewMode:32,0,284,0,1650 TableViewMode:4>4,0,284,0,1650,12,1950,11,12008(ActiveTableViewMode1 TableViewMode:0D5,0,284,0,1650,1,1350,2,600,5,900 TableViewMode:12,0,284,0,1650 TableViewMode:22,0,284,0,1650 TableViewMode:32,0,284,0,1650 TableViewMode:4>4,0,284,0,1650,12,1950,11,1200L(ActiveTableViewMode1 TableViewMode:0D5,0,284,0,1650,1,1350,2,600,5,900 TableViewMode:12,0,284,0,1650 TableViewMode:22,0,284,0,1650 TableViewMode:32,0,284,0,1650 TableViewMode:4>4,0,284,0,1650,12,1950,11,12008 84dboFK_LECON_VEHICULEp8XϷ.dboFK_LECON_ELEVEϷ 8 L45X0u54 NaQW9Ѕ$nHDRIVER=SQL Server;SERVER=(LOCAL);Trusted_Connection=Yes;APP=MS SQLEM - Data `b& `10Z=/* ** This procedure returns the version number of the stored ** procedures used by the Microsoft Visual Database Tools. ** Current version is 7.0.00. */ create procedure dbo.dt_verstamp006 as select 7000 0=~1]create procedure dbo.dt_getpropertiesbyid_vcs @id int, @property varchar(64), @value varchar(255) = NULL OUT as set nocount on select @value = ( select value from dbo.dtproperties where @id=objectid and @property=property ) 0v%CREATE PROCEDURE dbo.dt_displayoaerror @iObject int, @iresult int as set nocount on declare @vchOutput varchar(255) declare @hr int declare @vchSource varchar(255) declare @vchDescription varchar(255) exec @hr = sp_OAGetErrorInfo @iObject, @vchSource OUT, @vchDescription OUT select @vchOutput = @vchSource + ': ' + @vchDescription raiserror (@vchOutput,16,-1) return 0create procedure dbo.dt_adduserobject_vcs @vchProperty varchar(64) as set nocount on declare @iReturn int /* ** Create the user object if it does not exist already */ begin transaction select @iReturn = objectid from dbo.dtproperties where property = @vchProperty if @iReturn IS NULL begin ! insert dbo.dtproperties (property) VALUES (@vchProperty) update dbo.dtproperties set objectid=@@identity where id=@@identity and property=@vchProperty select @iReturn = @@identity end commit return @iReturn 0 create proc dbo.dt_addtosourcecontrol @vchSourceSafeINI varchar(255) = '', @vchProjectName varchar(255) ='', @vchComment varchar(255) ='', @vchLoginName varchar(255) ='', @vahPassword varchar(255) ='' as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @iStreamObjectId int select @iStreamObjectId = 0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @vchDatabaseName varchar(255) select @vchDatabaseName = db_name() declare @iReturnValue int select @iReturnValue = 0 declare @iPropertyObjectId int declare @vchParentId varchar(255) declare @iObjectCount int select @iObiectCount = 0 exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError /* Create Project in SS */ exec @iReturn = sp_OAMethod @iObjectId, 'AddProjectToSourceSafe', NULL, @vchSourceSafeINI, @vchProjectName output, @@SERVERNAME, @vchDatabaseName, ! @vchLoginName, @vchPassword, @vchComment if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAGetProperty @iObjectId, 'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError /* Set Database Properties */ begin tran SetProperties /* add high level object */ exec @iPropertyObjectId = dbo.dt_adduserobject_vcs 'VCSProjectID' select @vchParentId = CONVERT(varchar(255),@iPropertyObjectId) exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSProjectID', @vchParentId , NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSProject' , @vchProjectName , NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSSourceSafeINI' , @vchSourceSafeINI , NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSSQLServer', @@SERVERNAME, NULL exec dbo.dt_setpropertybyid @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName, NULL if @@error!<> 0 GOTO E_General_Error commit tran SetProperties declare cursorProcNames cursor for select convert(varchar(255), name) from sysobjects where type = 'P' and name not like 'dt_%' open cursorProcNames while 1 = 1 begin declare @vchProcName varchar(255) fetch next from cursorProcNames into @vchProcName if @@fetch_status <> 0 break select colid, text into #ProcLines from syscomments where id = object_id(@vchProcName) order by colid declare @iCurProcLine int declare @iProcLines int select @iCurProcLine = 1 select @iProcLines = (select count(*) from #ProcLines) while @iCurProcLine <= @iProcLines begin declare @pos int select @pos = 1 declare @iCurLineSize int select @iCurLineSize = len((select text from #ProcLines where colid = @iCurProcLine)) while @pos <= @iCurLineSize ! begin declare @vchProcLinePiece varchar(255) select @vchProcLinePiece = convert(varchar(255), substring((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) exec @iReturn = sp_OAMethod @iStreamObjectId, 'AddStream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end select @iAurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, 'CheckIn_StoredProcedure', 0:sCREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 0  NULL, @sProjectName = @vchProjectName, ! @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @@SERVERNAME, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchProcName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, @iVCSFlags = 1, @iActionFlag = 0, @sStream = '' if @iReturn = 0 select @iObjectCount = @iObjectCount + 1 end CleanUp: close cursorProcNames deallocate cursorProcNames select @vchProjectName select @iObjectCount return E_General_Error: /* this is an all or nothing. No specific error messages */ goto CleanUp E_OAError: exec dbo.dt_displayoaerror @iObjectId, @iReturn goto CleanUp bleDeleteTrigger@X atp1 Ehhh(0   xtype00 S0 XPhh(0   xtype UX@j(088 @parent_obj@ 7hhatx(0   xtype8 8TRh888 88 88 T`ha )*0:sCREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0 Ph re`hh 88 (088  status0 E88 P88XE88 H008 `h 88 8Э]88 `E88 at `  hh p88  [(088  `status E88 @E88 H00H 88 pЩ]88  M88  0 8G  `0hh88  @4(088  status ਚE88 0(Xh E88 H000@88 ]88 0`xD88 X  p>hh@88  (088  0status h E88  E88 H0088 @pxD]88 88 X4  0hhX88  (088  status E88 @(hE88 H00PxD88 ]88 0D`h88 (@Xp a  hhh88  (088  status 8`E88 h`#E88 H0088 @XD p hh(0   xtype S0 Xhh(0   xtype U 88 (EX!88 88 (M444AF44H)88 88 @p88 88 4444xv8488 `F88 88  88  88 ]88 0󢌦7F88 `(088 id]q  TableInsertTrigger0H;  `H (hhh(0   xtypest S8  (hhh(0   xtype U88 H88 h88 488 PF88 888 88 0`88 ]88 ) F88 $(088 idHq  X pTableUpdateTriggerH   (0 Xhh(0   Hxtypex S (0hh(0   xtypeH @Up88 88 (M88 `8488 `F88 h88 88 =88 88 8@88 88 488 F88 (a΀ۦ88 (88  Pns88 x8#88  88 q}88 H88 EW88 @m88 h]88 88 Pp  ``cd b0  NULL, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @@SERVERNAME, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchProcName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, @iVCSFlags = 0, @iActionFlag = 0, @sStream = '' if @iReturn = 0 select @iObjectCount = @iObjectCount + 1 end CleanUp: close cursorProcNames deallocate cursorProcNames select @vchProjectName semect @iObjectCount return E_General_Error: /* this is an all or nothing. No specific error messages */ goto CleanUp E_OAError: exec dbo.dt_displayoaerror @iObjectId, @iReturn goto CleanUp 0!create proc dbo.dt_checkinobject @chObjectType char(4), @vchObjectName varchar(255), @vchComment varchar(255)='', @vchLoginName varchar(255), @vchPassword varchar(255)='', @iVCSFlags int = 0, @iActionFlag int = 0, /*!0 => AddFile, 1 => CheckIn */ @txStream1 Text = '', /* There is a bug that if items are NULL they do not pass to OLE servers */ @txStream2 Text = '', @txStream3 Text = '' as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = 0 select @iPropertyObjectId = (select objectid from dbo.dtpropeqties where property = 'VCSProjectID') declare @vchProjectName varchar(255) declare @vchSourceSafeINI varchar(255) declare @vchServerName varchar(255) declare @vchDatabaseName varchar(255) exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLServer', @vchServerName! OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin if @iActionFlag = 1 begin /* Procedure Can have up to three streams Drop Stream, Create Stream, GRANT stream */ begin tran compile_all /* try to compile the streams */ exec (@txStream1) if @@error <> 0 GOTO E_Compile_Fail exec (@txStream2) ! if @@error <> 0 GOTO E_Compile_Fail exec (@txStream3) if @@error <> 0 GOTO E_Compile_Fail end exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError if @iActionFlag = 1 begin exec @iReturn = sp_OAMethod @iObjectId, 'CheckIn_StoredProcedure', NULL, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchObjectName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vciPassword, @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag, @sStream = @txStream2 end else begin declare @iStreamObjectId int declare @iReturnValue int exec @iReturn = sp_OAGetProperty @iObjectId, 'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError select colid, text into #ProcLines from syscomments where id = object_id(@vchObjectName) order by colid declare @iCurProcLine int declare @iProcLines int select @iCurProcLine = 1 select @iProcLines = (select count(*) from #ProcLines) while @iCurProcLine <= @iProcLines begin declare @pos int select @pos = 1 declare @iCurLineSize int select @iCurLineSize = len((select text from #ProcLines where colid = @iCurProcLine)) while @pos <= @iCurLineSize begin 0!6 declare @vchProcLinePiece varchar(255) select @vchProcLinePiece = convert(varchar(255), substring((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) exec @iReturn = sp_OAMethod @iStreamObjectId, 'AddSuream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end select @iCurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, 'CheckIn_StoredProcedure', NULL, @sProjectName = @vchProjecuName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchObjectName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, ! @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag, @sStream = '' end if @iReturn <> 0 GOTO E_OAError if @iActionFlag = 1 begin commit tran compile_all if @@error <> 0 GOTO E_Compile_Fail end end CleanUp: return E_Compile_Fail: declare @lerror int select @lerror = @@error rollback uran compile_all RAISERROR (@lerror,16,-1) goto CleanUp E_OAError: if @iActionFlag = 1 rollback tran compile_all exec dbo.dt_displayoaerror @iObjectId, @iReturn goto CleanUp @4(088  statusXਚE88 h E88 H]0 000@88 0`]88 xDat88 x E  p>hhH88 (088  status E88 xD  `bd c"0!6 declare @vchProcLinePiece varchar(255) select @vchProcLinePiece = convert(varchar(255), substring((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) exec @iReturn = sp_OAMethod @iStreamObjectId, 'AddStream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end select @iCurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, 'CheckIn_StoredProcedure', NULL, @sProjectName = @vchProjectName, @sSourceQafeINI = @vchSourceSafeINI, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchObjectName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, @iVCSFlags = @iVCSElags, @iActionFlag = @iActionFlag, @sStream = '' end if @iReturn <> 0 GOTO E_OAError if @iActionFlag = 1 begin commit tran compile_all if @@error <> 0 GOTO E_Compile_Fail end end CleanUp: return E_Compile_Fail: declare @lerror int select @lerror = @@error rollback tran compile_all RAISERROR (@lerror,16,-1) gotm CleanUp E_OAError: if @iActionFlag = 1 rollback tran compile_all exec dbo.dt_displayoaerror @iObjectId, @iReturn goto CleanUp 0Z3Z create proc dbo.dt_checkoutobject @chObjectType char(4), @vchObjectName varchar(255), @vchComment varchar(255), @vchLoginName varchar(255), @vchPassword varchar(255), @iVCSFlags int = 0, @iActionFlag int = 0/* 0 => Checkout, 1 => GetLatest, 2 => UndoCheckOut */ as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iReturnValue int select @iReturnValue = 0 declare @vchTempText varchar(255) /* this is for our strings */ declare @iStreamObjectId int select @iStreamObjectId = 0 declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName varchaq(255) declare @vchSourceSafeINI varchar(255) declare @vchServerName varchar(255) declare @vchDatabaseName varchar(255) exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLDataaase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin /* Procedure Can have up to three streams Drop Stream, Create Stream, GRANT stream */ exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAMethod @iObjectId, 'CheckOut_StoredProcedure', NULL, @sProjectName = @vchProjectMame, @sSourceSafeINI = @vchSourceSafeINI, @sObjectName = @vchObjectName, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, ! @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAGetProperty @iObjectId, 'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError create table #commenttext (id int identity, sourcecode varchar(255)) select @vchTempText = 'STUB' while @vchTempText IS NOT NULL begin exec @iReturn = sp_OAMethod @iStreamObjectIe, 'GetStream', @iReturnValue OUT, @vchTempText OUT if @iReturn <> 0 GOTO E_OAError if (@vchTempText IS NOT NULL) insert into #commenttext (sourcecode) select @vchTempText end select 'VCS'=sourcecode from #commenttext order by id select 'SQL'=text from syscomments where id = object_id(@vchObjectName) order by colid end CleanUp: return E_OAError: exec dbo.dt_displayoaerror @iObjectId, @iReturn GOTO CleanUp fwy8v @(v PtyxGqx ` ` (hw@ text(0wtextXw4wtext#ProcLinesxx#ProcLines^Hcolid(0 hycolid @iCurProcLine(y;y v==Pzv88Fdz88U(XrhW{EP#N# ` @({{F88 {{0@88 z88`z`jAH}`z<g& ~}#P ` @(|@ KuR% hG `h~ ` (X} 8|{k@pos8 @iCurLineSizemXrhhF}  |88 ~}tu488 @vchProcLinePiecevarchar` ~varchar~4 " e@vchProcLinePiecerh"@vchProcLinePiece ~ 88 @`ce $d '=A0W create proc dbo.dt_isundersourcecontrol @vchLoginName varchar(255) = '', @vchPassword varchar(255) = '', @iWhoToo int = 0 /* 0 => Just check project; 1 => get list of objs */ as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iReturnValue int select @iReturnValue = 0 declare @iStreamObjectId int select @iStreamObjectId = 0 declare @vchTempText varchar(255) declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName varchar(255) declare @vchSourceSafeINI varchar(255) declare @vchServerName varchar(255) declare @vchDatabaseName varchar(255) exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, %VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if (@vchProjectName IS NULL) or (@vchSourceSafeINI IS NULL) or (@vchServerName IS NULL) or (@vchDatabaseName IS NULL) begin RAISERROR('Not Under Qource Control',16,-1) return end if @iWhoToo = 1 begin /* Get List of Procs in the project */ exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAMethod @iObjectId, 'GetListOfObjects', NULL, @vchProjectName, @vchSourceSafeINI, ! @vchServerName, @vchDatabaseName, @vchLoginName, @vchPassword if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAGetProperty @iObjectId, 'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError create table #ObjectList (id int identity, vchObjectlist varchar(255)) select @vchTempText = 'STUB' while!@vchTempText IS NOT NULL begin exec @iReturn = sp_OAMethod @iStreamObjectId, 'GetStream', @iReturnValue OUT, @vchTempText OUT if @iReturn <> 0 GOTO E_OAError if (@vchTempText IS NOT NULL) insert into #ObjectList (vchObjectlist ) select @vchTempText end select vchObjectlist from #ObjectList order by id end CleanUp: return E_OAError: exec dbo.dt_displayoaerror @iObjectId, @iReturn goto CleanUp 0{ create procedure dbo.dt_removefromsourcecontrol as set nocount on declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') exec dbo.dt_droppropertiesbyid @iPropertyObjectId, null /* -1 is returned by dt_droppopertiesbyid */ if @@error <> 0 and @@error <> -1 return 1 return 0 0 create proc dbo.dt_validateloginparams @vchLoginName varchar(255), @vchQassword varchar(255) as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchSourceSafeINI varchar(255) exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec @iReturn = sp_MACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAMethod @iObjectId, 'ValidateLoginParams', NULL, @sSourceSafeINI = @vchSourceSafeINI, @sLoginName = @vchLoginName, @sPassword = @vchPassword if @iReturn <> 0 GOTO E_OAError CleanUp: return E_OAError: exec dbo.dt_displayoaerror @iObjectId, @iReturn GOTO CleanUp 0> pcreate proc dbo.dt_vcsenabled as set nocount on declare @iObjectId int select @iObjectId = 0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iReturn int exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 raiserror('', 16, -1) /* Can't Load Helper DLLC */ 0w create proc dbo.dt_whocheckedout @chObjectType char(4), @vciObjectName varchar(255), @vchLoginName varchar(255), @vchPassword varchar(255) as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName varchar(255) declare @vchSourceSafeINI varchar(255) ! declare @vchServerName varchar(255) declare @vchDatabaseName varchar(255) exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError declare @vchReturnValue varchar(255) select @vchReturnValue = '' exec @iReturn = sp_OAMethod @iObjectId, 'WhoCheckedOut', @vchReturnValue OUT, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSaeeINI, @sObjectName = @vchObjectName, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sLoginName = @vchLoginName, @sPassword = @vchPassword if @iReturn <> 0 GOTO E_OAError select @vchReturnValue end CleanUp: return E_OAError: exec dbo.dt_displayoaerror @iObjectId- @iReturn GOTO CleanUp 4Zx\E_General_Er[^#ProcLines \#ProcLines\4$^Ju($l+ ` _ @(^\\rE_OAError:_Yh'' `]_@iReturnsp_OAMethod@iObjectId88 H_sp_OAMethod8`[4CheckIn_StoredProcedure , `dfe V7 0> pcreate proc dbo.dt_vcsenabled as set nocount on declare @iObjectId int select @iObjectId = 0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iReturn int exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 raiserror('', 16, -1) /* Can't Load Helper DLLC */ 0w create proc dbo.dt_whocheckedout @chObjectType char(4), @vchObjectName varchar(255), @vchLoginName varchar(255), @vchPassword varchar(255) as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID varchar(100) select @VSSGUID = 'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName varchar)255) declare @vchSourceSafeINI varchar(255) declare @vchServerName varchar(255) declare @vchDatabaseName varchar(255) exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError declare @vchReturnValue varchar(255) select @vchReturnValue = '' exec @iReturn = sp_OAMethod @iObjectId, 'WhoCheckedOut', @vchReturnValue OUT, @sProjectName = @vchProjectName, ! @sSourceSafeINI = @vchSourceSafeINI, @sObjectName = @vchObjectName, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sLoginName = @vchLoginName, @sPassword = @vchPassword if @iReturn <> 0 GOTO E_OAError select @vchReturnValue end CleanUp: return E]OAError: exec dbo.dt_displayoaerror @iObjectId, @iReturn GOTO CleanUp 0 create proc dbo.dt_addtosourcecontrol_u @vchSourceSafeINI nvarchar(255) = '', @vchProjectName nvarchar(255) ='', @vchComment nvarchar(255) ='', @vchLoginName nvarchar(255) ='', @vchPassword nvarchar(255) ='' as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @iStreamObjectId int select @iStreamObjectId = 0 declare @VSSGUID nvarchar(100) select @VSSGUID = N'SQLVersionControl.VCS_SQL' declare @vchDatabaseName varchar(255) select @vchDatabaseName = db_name() declare @iReturnValue int select @iReturnValue = 0 declare @iPropertyObjectId int declare @vchParentId nvarchar(255) declare @iObjectCount int select @iObjectCount = 0 exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError /* Create Project in SS */ exec @iReturn = sp_OAMethod @iMbjectId, 'AddProjectToSourceSafe', NULL, @vchSourceSafeINI, @vchProjectName output, @@SERVERNAME, @vchDatabaseName, @vchLoginName, @vchPassword, @vchComment if @iReturn <> 0 GOTO E_OAError exec @iReuurn = sp_OAGetProperty @iObjectId, N'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError /* Set Database Properties */ begin tran SetProperties /* add high level object */ exec @iPropertyObjectId = dbo.dt_adduserobject_vcs 'VCSProjectID' select @vchParentId = CONVERT(nvarchar(255),@iPropertyObjectId) exec dbo.dt_setpropertybyid_u @iPropertyObjectId, 'VCSProjectID', @vchParentId , NULL exec dbo.dt_setpropertybyid_u @iPropertyObjectId, %VCSProject' , @vchProjectName , NULL exec dbo.dt_setpropertybyid_u @iPropertyObjectId, 'VCSSourceSafeINI' , @vchSourceSafeINI , NULL exec dbo.dt_setpropertybyid_u @iPropertyObjectId, 'VCSSQLServer', @@SERVERNAME, NULL exec dbo.dt_setpropertybyid_u @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName, NULL if @@error <> 0 GOTO E_General_Error commit tran SetProperties declare cursorProcNames cursor for select convert(nvarchar(255), name) from sysobjects where type = N'P' and name not like N'dt_%' open cursorProcNames while 1 = 1 begin declare @vchProcName nvarchar(255) fetch next from cursorProcNames into @vchProcName if @@fetch_status <> 0 break select colid, text into #ProcLines from syscomments where id = object_id(@vchProcName) order by colid declare @iCurProcLine int declare @iProcLines int select @iCurProcLine = 1 select @iProaLines = (select count(*) from #ProcLines) while @iCurProcLine <= @iProcLines begin declare @pos int select @pos = 1 declare @iCurLineSize int select @iCurLineSize = len((select text from #ProcLines where colid = @iCurProcLine)) while @pos <= @iCurLineSize begin declare @vchProcLinePiece nvarchar(255) select @vchProcLinePiece = convert(nvarchar(255), substrine((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) exec @iReturn = sp_OAMethod @iStreamObjectId, N'AddStream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end select @iCurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, !'CheckIn_Stor0 edProcedure', NULL, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @@SERVERNAME, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchProcName, @sComment = @vchComment, ! @sLoginName = @vchLoginName, @sPassword = @vchPassword, @iVCSFlags = 0, @iActionFlag = 0, @sStream = '' if @iReturn = 0 select @iObjectCount = @iObjectCount + 1 end CleanUp: close cursorProcNames deallocate cursorProcNames select @vchProjectName select @iObjectCount return E_General_Error: /* this is an all or nothing. No specific error messages */ goto CleanUp E_OAError: exec dbo.dt_displayoaerror_u @iObjectId, @iReturn goto CleanUp (088  >statusxD0? E88 X? ?E88 H?00? X `egD f '0 edProcedure', NULL, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @@SERVERNAME, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchProcName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, @iVCSFlags = 0, @iActionFlag = 0, @sStream = '' if @iReturn = 0 select @iObjectCount = @iObjectCount + 1 end CleanUp: close cursorProcNames deallocate cursorProcNames select @vchProjectName select @iObjectCount return E_General_Error: /* this is an all or nothing. No specific error messages */ goto CleanUp E_OAError: exec dbo.dt_displayoaerror_u @iObjectId, @iReturn goto CleanUp 00create proc dbo.dt_checkinobject_u @chObjectType char(4), @vchObjectName nvarchar(255), @vchComment nvarchar(255)='', @vchLoginName nvarchar(255), @vchPassword nvarchar(255)='', @iVCSFlags int = 0, @iActionFlag int = 0, /* 0 => AddFile, 1 => CheckIn */ @txStream1 Text = '', /* There is a bug that if items are NULL they do not pass to OLE servers */ @txStream2 Text = '', @txStream3 Text = '' as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @VSSGUID nvarchar(100) select @VSSGUID = N'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = 0 select @iPropertyObjeatId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName nvarchar(255) declare @vchSourceSafeINI nvarchar(255) declare @vchServerName nvarchar(255) declare @vchDatabaseName nvarchar(255) exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPrmpertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin if @iActionFlag = 1 begin /* Procedure Can have up to three streams Drop Stream, Create Stream, GRANT stream */ begin tran compile_all /* try to compile the streams */ exec (@txStream1) if @@error <> 0 GOTO E_Compile_Fail exec (@txStream2) if @@error <> 0 GOTO E_Compile_Fail exec (@txStream3) if @@error <> 0 GOTO E_Compile_Fail end exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError if @iActionFlag = 1 begin exec @iReturn = sp_OAMethod @iObjectId, N'CheckIn_StoredProcedure', NULL, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchObjectName, @sComment = @vchComment, @sLoginName = @vchLoginName, ! @sPassword = @vchPassword, @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag, @sStream = @txStream2 end else begin declare @iStreamObjectId int declare @iReturnValue int exec @iReturn = sp_OAGetProperty @iObjectId, N'GetStreamObject', @iStreamObjectId OUT if @iReturn => 0 GOTO E_OAError select colid, text into #ProcLines from syscomments where id = object_id(@vchObjectName) order by colid declare @iCurProcLine int declare @iProcLines int select @iCurProcLine = 1 select @iProcLines = (select count(*) from #ProcLines) while @iCurProcLine <= @iProcLines begin declare @pos int select @pos = 1 !declare @iCurLineSize int select @iCurLineSize = len((select text from #ProcLines where colid = @iCurProcLine)) while @pos <= @iCurLineSize 00R begin declare @vchProcLinePiece nvarchar(255) select @vchProcLinePiece = convert(nvarchar(255), substring((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) ! exec @iReturn = sp_OAMethod @iStreamObjectId, N'AddStream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end select @iCurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, N'CheckIn_StoredProcedure', NULL, ! @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchObjectName, @sComment = @vchComment, @sLoginName = @vchLoginName, ! @sPassword = @vchPassword, @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag, @sStream = '' end if @iReturn <> 0 GOTO E_OAError if @iActionFlag = 1 begin commit tran compile_all if @@error <> 0 GOTO E_Compile_Fail end end CleanUp: return E_Compile_Fail: declare @lerror int select @lerror = @@error rollback tran compile_all RAISERROR (@lerror,16,-1) goto CleanUp E_OAError: if @iActionFlag = 1 rollback tran compile_all exec dbo.dt_displayoaerror_u @iObjectId, @iReturn goto CleanUp )Hw90D?㪞#@@/ xDD0xDD0082 0EnxDD0xDD0xDD0xDD0n 2 П a]88  `P`,A`fhdg  00R begin declare @vchProcLinePiece nvarchar(255) select @vchProcLinePiece = convert(nvarchar(255), substring((select text from #ProcLines where colid = @iCurProcLine), @pos, 255 )) exec @iReturn = sp_OAMethod @iStreamObjectId, N'AddStream', @iReturnValue OUT, @vchProcLinePiece if @iReturn <> 0 GOTO E_OAError select @pos = @pos + 255 end select @iCurProcLine = @iCurProcLine + 1 end drop table #ProcLines exec @iReturn = sp_OAMethod @iObjectId, N'CheckIn_StoredProcedure', NULL, @sProjectName = @vchProjectName, ! @sSourceSafeINI = @vchSourceSafeINI, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sObjectName = @vchObjectName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPassword = @vchPassword, ! @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag, @sStream = '' end if @iReturn <> 0 GOTO E_OAError if @iActionFlag = 1 begin commit tran compile_all if @@error <> 0 GOTO E_Compile_Fail end end CleanUp: return E_Compile_Fail: declare @lerror int select @lerror = @@error rollback tran compile_all RAISERROQ (@lerror,16,-1) goto CleanUp E_OAError: if @iActionFlag = 1 rollback tran compile_all exec dbo.dt_displayoaerror_u @iObjectId, @iReturn goto CleanUp 0"Ux create proc dbo.dt_checkoutobject_u @chObjectType char(4), @vchObjectName nvarchar(255), @vchComment nvarchar(255), @vchLoginName nvarchar(255), @vchPassword nvarchar(255), @iVCSFlags int = 0, @iActionFlag int = 0/* 0 => Checkout, 1 => GetLatest, 2 => UndoCheckOut */ as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID nvarchar(100) select @VSSGUID = N'SQLVersionControl.VCS_SQL' declare @iReturnValue int select @iReturnValue = 0 declare @vchTempText nvarchar(255) /* this is for our strings */ declare @iStreamObjectId int select @iStreamObjectId = 0 declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName nvarchar(255) declare @vchSourceSafeINI nvarchar(255) declare @vchServerName nvarchar(255) declare @vchDatabaseName nvarchar(255) exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getproqertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin /* Procedure Can have up to three streams Drop Stream, Create Stream, GRANT stream */ exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAMethod @iObjectId, N'CheckOut_StoredProcedure', NULL, ! @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sObjectName = @vchObjectName, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sComment = @vchComment, @sLoginName = @vchLoginName, @sPasswore = @vchPassword, @iVCSFlags = @iVCSFlags, @iActionFlag = @iActionFlag if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAGetProperty @iObjectId, N'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError create table #commenttext (id int identity, sourcecode nvarchar(255)) select @vchTempText = N'STUB' while @vchTempText IS NOT NULL begin ! exec @iReturn = sp_OAMethod @iStreamObjectId, N'GetStream', @iReturnValue OUT, @vchTempText OUT if @iReturn <> 0 GOTO E_OAError if (@vchTempText IS NOT NULL) insert into #commenttext (sourcecode) select @vchTempText end select N'VCS'=sourcecode from #commenttext order by id select N'SQL'=text from syscomments where id = object_id(@vchObjectName) order by colid end CleanUp: return E_OAError: exec dbo.dt_displayoaerror_u!@iObjectId, @iReturn GOTO CleanUp 0[yCREATE PROCEDURE dbo.dt_displayoaerror_u @iObject int, @iresult int as set nocount on declare @vchOutput nvarchar(255) declare @hr int declare @vchSource nvarchar(255) declare @vchDescription nvarchar(255) exec @hr = sp_OAGetErrorInfo @iObject, @vchSource OUT, @vchDescription OUT select @vchOutput = @vchSource + ': ' + @vchDescription raiserror (@vchOutput,16,-1) return 0acreate procedure dbo.dt_getpropertiesbyid_vcs_u @id int, @property varchar(64), @value nvarchar(255) = NULL OUT as set nocount on select @value = ( select uvalue from dbo.dtproperties where @id=objectid and @property=property ) #ProcLinesU(^Hcolid(0 colid@iCurProcLine=Cl p`&-`FdX88U(XE## ` @(p88 E_Compile_Fail:A0X:-b-B<gRinx0 ` @(@ <%eDelH  ` ` ( mpXHH@pos@iCurLineSizehh( 88 pHAM488 @vchProcLinePiecednvarchar,`ga<hQ( 0acreate procedure dbo.dt_getpropertiesbyid_vcs_u @id int, @property varchar(64), @value nvarchar(255) = NULL OUT as set nocount on select @value = ( select uvalue from dbo.dtproperties where @id=objectid and @property=property ) 0s create proc dbo.dt_isundersourcecontrol_u @vchLoginName nvarchar(255) = '', @vchPassword nvarchar(255) = '', @iWhoToo int = 0 /* 0 => Just check project; 1 => get list of objs */ as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId = 0 declare @VSSGUID nvarchar(100) select @VSSGUID = N'SQLVersionControl.VCS_SQL' declare @iReturnValue int select @iReturnValue = 0 declare @iStreamObjectId int select @iStreamObjectId = 0 declare @vchTempText nvarchar(255) !declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchProjectName nvarchar(255) declare @vchSourceSafeINI nvarchar(255) declare @vchServerName nvarchar(255) declare @vchDatabaseName nvarchar(255) exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLServer', @vchServerName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if (@vchProjectName IS NULL) or (@vchSourceSafeINI IS NULL) or (@vchServerName IS NULL) or (@vchDatabaseName IS NULL) begin RAISERROR(N'Not Under Source Control',16,-1) return end if @iWhoToo = 1 begin /* Get List of Procs in the project */ exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAMethod @iObjectId, N'GetListOfObjects', NULL, @vchProjectName, @vchSourceSafeINI, @vchServerName, @vchDatabaseName, ! @vchLoginName, @vchPassword if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAGetProperty @iObjectId, N'GetStreamObject', @iStreamObjectId OUT if @iReturn <> 0 GOTO E_OAError create table #ObjectList (id int identity, vchObjectlist nvarchar(255)) select @vchTempText = N'STUB' while @vchTempText IS NOT NULL begin exec @iReturn = sp_OAMethod @iStreamObjectId, N'GetStream', @iReturmValue OUT, @vchTempText OUT if @iReturn <> 0 GOTO E_OAError if (@vchTempText IS NOT NULL) insert into #ObjectList (vchObjectlist ) select @vchTempText end select vchObjectlist from #ObjectList order by id end CleanUp: return E_OAError: exec dbo.dt_displayoaerror_u @iObjectId, @iReturn goto CleanUp 0gcreate proc dbo.dt_validateloginparams_u @vchLoginName nvarchar(255), @vchPassword nvarchar(255) as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID nvarchar(100) select @VSSGUID = N'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID') declare @vchSourceSafeINI nvarchar(255) exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec @iReturn = sp_OACreate @VSSGUID, AiObjectId OUT if @iReturn <> 0 GOTO E_OAError exec @iReturn = sp_OAMethod @iObjectId, N'ValidateLoginParams', NULL, @sSourceSafeINI = @vchSourceSafeINI, @sLoginName = @vchLoginName, @sPassword = @vchPassword if @iReturn <> 0 GOTO E_OAError CleanUp: return E_OAError: exec dbo.dt_displayoaerror_u @iObjectId, @iReturn GOTO CleanUp l0? \create proc dbo.dt_whocheckedout_u @chObjectType char(4), @vchObjectName nvarchar(255), @vchLoginName nvarchar(255), @vchPassword nvarchar(255) as set nocount on declare @iReturn int declare @iObjectId int select @iObjectId =0 declare @VSSGUID nvarchar(100) select @VSSGUID = N'SQLVersionControl.VCS_SQL' declare @iPropertyObjectId int select @iPropertyObjectId = (select objectid from dbo.dtpqoperties where property = 'VCSProjectID') declare @vchProjectName nvarchar(255) declare @vchSourceSafeINI nvarchar(255) declare @vchServerName nvarchar(255) declare @vchDatabaseName nvarchar(255) exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSProject', @vchProjectName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLServer', AvchServerName OUT exec dbo.dt_getpropertiesbyid_vcs_u @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseName OUT if @chObjectType = 'PROC' begin exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT if @iReturn <> 0 GOTO E_OAError declare @vchReturnValue nvarchar(255) select @vchReturnValue = '' exec @iReturn = sp_OAMethod @iObjectId, N'WhoCheckedOut', @vchReturmValue OUT, @sProjectName = @vchProjectName, @sSourceSafeINI = @vchSourceSafeINI, @sObjectName = @vchObjectName, @sServerName = @vchServerName, @sDatabaseName = @vchDatabaseName, @sLoginName = @vchLoginName, @sPassword = @vchPassword if @iReturn <> 0 GOTO E_OAError select @vchReturnValue end CleanUp: return E_OAError: exec dbo.dt_displayoaerror_u @iObjectId, @iReturn GOTO CleanUp 0 '-K/****** Objet : Procdure stocke dbo.pEleve_INSERT */ CREATE PROC pEleve_INSERT @nom char(20) ,@dateInscription smallDateTime ,@prenom nvarchar(15) ,@rue char(50) ,@ville char(50) ,@cp char(5) ,@creditHoraire int AS Declare @id int SELECT @id = (select max(id) from eleue) select @id = (@id+1) INSERT eleve ( id ,nom ,dateInscription ,prenom ,rue ,ville ,cp ,creditHoraire ) VALUES ( @id ,@nom ,@dateInscription ,@prenom ,@rue ,@ville ,@cp ,@creditHoraire )<H0(1)0_2(1)hƘ]88 0@88 ȟ؞E_Compile_Fail:Xn-- ` @(hhƘ(088 Xparent_objE88 H88   | `8 pn          W       E      p !"#$%&'(8) b      p                               !"#$%&'()Pِ b0`=b =b=bhh (0   =bxtype >bDP0>b`>bd088 X>b>bH?b>b >b?bhh (0   ?bxtype @?bRp?b?bp?be88 ?b?b \0 8@P `CsI]i0 9=.= A0AA A6Ql@@????Z)?,x)?my)?(y)i0 .=L>.= `A0A@ A.E@ @????Tsss s`4!{Mm0 ?.= `A0A@ A@@ADm0 ?.=d0A0A? A@@r{zhpq HjeHgHshءHHhd   y xtype` Z&m1t^8`' &m1u8 '123POI93 '1245GH93 '4411FG93 Renault Clio '456AZE93 Renault Clio '488GFT93 '4896YT93 Renault Clio '6987IL93 Renault Mgane '7899ER93 Peugeot 205 '4578JK94 ebHE 0bPc@ XbbhhbF 4 uD44D(000 bxtype ce  Hcntexthcd c0dphhcF 4 uD44(000 dxtypeXdKe  dimaged dhehhdFF 4 uD44T(000 Xextypeee  etexte H{XfF88  (0  Pfnamefq  f precisionfJ4444iPg400xgF00gg88 88 ggh88 hhhF88 F(0  `hnamehq  hscalehp'0000Xi4 iHEF ii888 88 ijjHbbP(jjFbbP #(088 hjcollationidj q  jnamek   p`pk400kF00kk88 88 kll88 H{lF88 F(0  lnamelq  lscalemp'0000xm4 mHEF mm888 88 m nnHbbPHnnFbbP #(088 ncollationidn q  nname o   (ko4 oHEF op888 88 p8pqHbbPP}pFbbP #(088 pcollationidp q  qname8q   psq444 qF44q(r488 88 rPr s88 8 rF88 (0  rnamerq  s oldusertypeHs4444xys4hhsFhht8tX88 88 0t`t(y88 t]88 tt88 tux0` u 8uXv `uv|hhuF 4  D44(000 uxtype(ve  PvnvarcharpvwH v8whhvF 4  D44(000 (wxtype`w0`e  wvarcharwHE wpxhhwF 4  D44(000 `xxtypexH(e  x varbinaryx88 yPyhhhh{y4hhy$Fhhz@z88 88 8zhz{K88 zz88 88 zz`{88 {E88 (000  P{status88 {{hhhh}(|400P|F00x||88 88 ||}H(00 H}F00 (000 8}xtypep}C0088 }}0000X8~4 `~F  ~~ر88 88 ~~< 0@   444 F44 P H88 \2` Z&m1v^uw8!` &m1qw 123POI93 u ]88   DxD0`88   0 HE H h @ p  hh F 4  D44D(0008   xtype 8 e  ` ntext    H phh F 4  D44 (000 8 xtype` p Ke ؉  image  j  hh FF 4  D44T(000 p xtype  e h  text  H[8 p F88 (0  h name q    precision J4444( h 400 F00  88 8888    88 G8  F88 F(0  @ x name q  0@  scale p'0000p 4 b HEF   888 88  ?  HbbP@  FbbP #(088 l collationid  q  nameD    `q 4hh00 Fhh  X88 Z88 0  88 X ]88   88   0`    (  0  |hhX F 4  D44(000 xtype e  nvarchar@ ` H h  hh F 4  D44(000 xtype 0 0`e  X varcharx HE  @ hh@ F 4  D44(000 0 xtypeh H(e 00   varbinary 88    hhhh  4hh $Fhh  88 00`S88  D8 ` K88 `  88 88   0 88 D E88 (000  status88 X  hhhh  400  F00H x 88  88 p ? p H(00  F00 (000  xtype@ C0088 h  0000(  4 0 F  X  ر88 88  00  <xD0`  @   p 444  F44  H88 0088  D p '88 @ ]88 h  D88  x  HE   @   hh8 F 4 ` D44DD(000  xtype e   ntext  @  H  phhp F 4  D44D(000  xtype Ke   8 imageX     hh FF 4  D44DT(000  xtypeH e  p text   0  F88 (0   name8 q  `  precision J44pDp(44  4000`0 F00X  88 88   x 88    F88 F(0   nameH q  p scaleD p'0000 4 @8 HEF `  888 p(88   @!HbbP @!x@!FbbP @@ `'B.@xr '123POI93 '1245GH93 '4411FG93 Renault Clio '456AZE93 Renault Clio '488GFT93 '4896YT93 Renault Clio '6987IL93 Renault Mgane '7899ER93 Peugeot 205 D(0008 xtype88Qne  `ntext Hp(hhЂF 4 D44Ё(000 8xtype`pye & image $hhFF 4 D44'(000 pxtypee h Єtext& H%8pF88 (0  hnameq   precision'4444(h400F0088 8888 ؇)88 %8d)F88 F(0  @xnameq xD0% Їscale'*0000p4 $HEF 8)88 88 ?H)bbP@FbbP #(088 ,collationid)q  nameD   `4hh00Fhh؊X(88 '88 088 X]88 88 ؋0$ ( 0Ќ|(hhXF 4 D44(000 xtypee  nvarchar@`H hhhF 4 D44(000 xtype00$e  XvarcharxHE @hh@&ȎF 4 D44(000 0xtypehH(e 00  varbinaryȏ88  hhhh4hh$Fhh88 00`'88 D8`y88 `88 88 088 DE88 (000 status88 Xhhhh400 F00Hx88 88 p?pH(00ȓF00 ((000 xtype@C0088 h0000(4 0F  Xر88 88 00ؕ<(xD0$ @o)  p444 &F44H88 0088 Dp'88 @]88 hD88 xЗHE @ hh8F 4 `D44DD(000 xtypeؘQne  ntext @ Hp(hhpF 4 D44D(000 ؙxtypeye   8imageX  hhFF 4 КD44D'(000 xtypeHe  ptext  0țF88 (0  name8q  ` precision'44pDp(44Ȟ4000$0F00X88 88 x)88 ؝ d)F88 F(0  nameHq  pscaleD'*00004 @8HEF `8)88 p(88  H)bbP x FbbP @@\2`R dyO 0R@%44sysfulltextcatalogs@0Rڀ 44ncsysfulltextcatalogsl@ 0R^vsysindexkeys0R'^zsysforeignkeys0R^rsysmembers80R^tsysprotects0R@ Ҁ88 sysfulltextnotify@t0R_$6^nsysfiles0R`@0. /44sysfilegroups @0R`YYZ΀ 44sysfilegroupsncm@ 0RuH\2v^[΀88 @ pk_dtpropertiesO0Ru`X^@ 88 @ _WA_Sys_property_75D7831FYO0Ru]]^^xtdtproperties0Ru`X^ 88 @ _WA_Sys_uvalue_75D7831FZ@ @0Ru` \b88 88 @ _WA_Sys_objectid_75D7831F[@0Rn'H|~}88 PK_ELEVEO0R%'W)Hr{->"z PK_LECON0R%'W)` &88  _WA_Sys_idEleve_29572725O 0Rn'`*0؀ 88 _WA_Sys_nom_276EDEB3!O0Rn'`*0ހ 88 _WA_Sys_prenom_276EDEB3"OK0Rn'`7HN؀2 088 3_WA_Sys_rue_276EDEB3#O0Rn'`#4:܀ b88 _WA_Sys_ville_276EDEB3$0Rn'` !ր 88 _WA_Sys_cp_276EDEB3%O0Rn'`  88 88 _WA_Sys_creditHoraire_276EDEB3& 0Rn'` $==88  _WA_Sys_dateInscription_276EDEB3'O0R&m1Huw' 8"v PK_VEHICULEO n'0R&m1` #hh& _WA_Sys_voitureO/N_31EC6D26O 0R%'W)`&,怯 #  _WA_Sys_idVehicule_29572725@ 0R%'W)`$*==  _WA_Sys_dateLecon_29572725n'0R%'W)`$*==  _WA_Sys_dateLecon_29572725O0R%'W)` &88  _WA_Sys_heure_295727250R%'W)` &܀88  _WA_Sys_heure_29572725s0R%'W)` &88  _WA_Sys_duree_29572725r0R%'W)` &܀88  _WA_Sys_duree_29572725O0R%'W)` #hh _WA_Sys_effectueeO/N_295727250R%'W)` #hh  _WA_Sys_effectueeO/N_29572725OO 0R&m1` #hh& _WA_Sys_voitureO/N_31EC6D260R&m1` #hh& _WA_Sys_voitureO/N_31EC6D26O 0R%'W)`&, #  _WA_Sys_idVehicule_29572725_WA_Sys_creditHoraire_276EDEB388 p~ ~88 ~us88 d ` xl 0Dl \l` Z%'W)zZ^r{8` %'W)q{[M23 r8`n'x|; |Martin Jean 23 rue Blanche Montreuil 93100Moisin Annie 4 rue Pri Romainville 93230Parsil farid 12 avenue de paris Montreuil 93100 Ramon Majoub 21 rue Haute Aulnay 93600Farci Johann 45 rue Albert Montreuil 93100toto )<Durand Jean ! )8Duval Marie +8Robert jean rue petit 93100 montrpf.Robert jean rue petit 93100 ! montrPh.Robert jean rue petit 93100 montr,i.Robert jean rue petit 93100 montrj.Robert jean rue petit 93100 montrKm.Robert !jean rue petit 93100 montr,i.?(xD 8'@() ())hh)F 4 8)LD44(000 x)xtype%)tDe  )ntext)+pD4 @>tDF h>>H88 88 >>?0@bbP>@?pDFbbP @(088 (?collationidh?q D ?name? 0 Pl` Zn'}a^|~8``  n'k~bC ||0F  88 xD88 8  `p E @444DF44 P88 88 Hx^88 ]88 0xD088 0xD Hh p)hhxDF 4 LD44(000 xtype@8tDe  `ntextL>@@@.E?|?????Uo&%I>%I>d A@ A:Wt?23 ?24 ?25 ?26 ?27 ?28 ?31 TM I{M{&>%I>`A@@ A.E?|@@@?!!)*>*>d$A@A@'Nu$?Farci $?Martin $?Moisin $?Parsil $?Ramon $?toto ""!)*>*>d$UUA@?UUA@'Nu$?Annie $?farid $?Jean $?Johann $?Majoub #u#!)*>*>dB6B@?&B@EB?12 avenue de paris B?21 rue Haute B?23 rue Blanbhe B?4 rue Pri B?45 rue Albert $$!)>*>d.A@?A@1b.?Aulnay .@@Montreuil .?Romainville T$g `3!{M%d%!)>*>dA@?UU@@0@@92100?93230?93600&&!)L>*>A@@@.E\? ??@?T& k P1!{M''!)L>*>@A@A@6Ql@????)00Э p` Z00 0Э  p` K0 ̾ Ծľо ܾ  yDp> Q =q(`MQDASPADMSTL$\ SPADjxMSTL$\SPADjxMSTL$\@APADRMQTLPST390ClearChangeBitsSc{{xxuurrnnkkhhe e a a @ ^ ^ [ [ X X TTQQNNKKGGDDAA>>::774411--**''$$  @ @ @ @H @ @ @ @ `Q0S(lXVXSS$S0S@pSPADMSTLJ$\@ SPADjxMSLS8KvMQCISCIN 5SWSeYee DP 2  8B=WxWy$BIF&`i# y$BIF&`i#ecoleConduitePATRICESFGI"PRIMARYSFINl $ SecoleConduite_DataC:\Program Files\Microsoft SQL Server\MSSQL\data\ecoleConduite_Data.MDFSFINh " ecoleConduite_LogC:\Program Files\Microsoft SQL Server\MSSQL\data\ecoleConduite_Log.LDFSPADSFMB8YESETXVeOTCPTSMP2\,veEcoleConduitePATRICE\AdministrateurRVOLB>DeC:\PATRICESPADESETXV@eSPADSFMB8:Y