forked from way0utwest/usingcitopreventdbproblems
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path10_Load_SimpleTalk_Data.sql
67 lines (63 loc) · 66.4 KB
/
10_Load_SimpleTalk_Data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
SET IDENTITY_INSERT dbo.Contacts ON
go
INSERT INTO dbo.Contacts
([ContactsID], [ContactFullName], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [CountryCode], [JoiningDate], [ModifiedDate], [Email], [Photo], [StatusID])
VALUES
( 1, N'Louis Davidson', N'01446 175923', N'07634 717173', N'17 High Street', N'Darlington', N'Cheshire', N'US', N'2007-09-14T16:09:21.383', GETDATE(), N'[email protected]', 0xffd8ffe000104a46494600010101004800480000ffdb0043000604040405040605050609060506090b080606080b0c0a0a0b0a0a0c100c0c0c0c0c0c100c0e0f100f0e0c1313141413131c1b1b1b1c20202020202020202020ffdb0043010707070d0c0d181010181a1511151a20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020ffc00011080053004103011100021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00fa7355d47ec16eb3797e66e7098cedea09f43e95cb8bc4fb18ded7d4da8d2e77632bfe12effa74ff00c89ffd8d79dfdb1fddfc7fe01d3f51f30ff84bf00936b803924c9c7fe8347f6c7f77f1ff00801f51f3fc0a13fc4dd12065595e205feee26dd9ff00be54d52cd9ff0027e3ff0000afece7dff02cd978f2c6f81368a936de182cbc8fa8db9a4f37feefe3ff00004f00d75fc09ffe12cffa75ff00c89ffd8d2fed8feefe3ff009fa97989ff0977fd3a7fe44ff00ec68fed8feefe3ff00007f52f33574ad47edf6ed3797e5ed7298ceee801cf41eb5e8e1313eda37b5b539ab52e4762ed751898de2bff907c7ff005d47fe82d5e5e6dfc35fe2fd19d783f8be4726ee91c6d239c220dcc7d857ce9e9a384f13eb516a0a6ca5baf2e2b8ff0055671fdedbfde908f5aeba748eb8d3b1cadeeb7259f9715b4276a7c802ff007477ae8b1a72b3420886a966b7d6dbe2b984e5655f94e4751918cd4b8899da78575dbfba54835070ecc3f7729186247afad72d4a5630a94ce948ac0e73a8f0affc83e4ff00aea7ff00415afa2ca7f84ffc5fa23cdc67c5f2366bd4390c6f157fc83e3ffaea3ff416af2f36fe1aff0017e8cebc1fc5f2381f12c84692f12fde9cf97fd4d7854d6a7b1496a725a5f87ac6de3566fdeccc3e695b93f4aeb3d386c6eda689a505dcd186c8ef5aa899caa301a3dbdbcb21813f7120ff00563030477a7ca2bdfd48d6d922b980ae76ef407f3eb594f622a2d0eb0f5af38f34e9fc2dff0020f93feba9ff00d056be8b28fe13ff0017e88f3b19f17c8d8af50e4313c58db74e8cff00d361ff00a0b57979b7f0d7f8bf467660be3f91e65e31d4a2b7b480b1c9dcc7cb5e588039217a9c679af0e8ee7b94206145e23d1d230f35ec28a7eefce327e8bd6ba923bd35627d3fc77e1d9ee859c3740cb9dbf3064ffd0b15ba4d11cb72f6bbe2ed1f478c35fce91123705c82c7e829ee42818173f127c302cfed62e0a26e420c836a9cb81f7f951d7d6a1c18a6d729e9ff00afbd796cf30ea3c2ff00f20f93feba9ffd056be8728fe13ff17e88f3719f17c8d8af50e439bf1e36dd1e23ff004dd7ff00407af2b37fe12ff17e8cf432dfe27cbfc8f24f1189258e39628d64b884feef7e7003901cf1cf415e1d07a9f4d43b1c7ea1f0cec2fb569f57d3ff007173729e54f0a9d99da7e5747c1dac4707d6bbe159f2d84f0f152e65d48a6f85f0c3a6dd411e9a96c6e370fb54f3f9855a41b49c72c703ee8f5ad9d408d25b17bfe1577872cee76e9fa7db0b4b98228a7b7b866c9962046f566f307cea7e65e39e69baad911c3c56c6a2f8074d58fecf716b6f0594a6237369065966113065561c281f28cf7ac6527b8e514d58f51273cd796794751e16ff00907c9ff5d4ff00e82b5f4394ff0009ff008bf447998cf8be46cd7a8721cb7c456c68711ffa785ffd01ebcacdff0084bfc5fa33d1cb3f88fd3fc8f03f88fe323e17d2adf511109964bc8a19633c1311c9936fbe0715e460a87b49dbc8f66ae23d92b9bd6979875f2cee561946f50791fa56b1d0f537447ac5fcece02dc430dcc63f770dd1214e7f8b8ef5b6e38a5d01751d42eecd60d4b63be0854b4469338e8dbb0314d8946da9a4b2491d8f9f3bf11c65d9bfd9519fe42a1ea6526719a7fed47e147c2ea1a4de5b762d0b4730fae098cd3965b2ee784ea2b9ef3f0a7c61a0f8b3c372ea7a24cd35aadd342e5d0c6cb208e362a41f671d2bd3cba93841a7dffc8f3718fdef91d9d779ca79a7ed01e2c8fc2fe088750687cf792f6382142db577b432b65bbe3087a57163e8fb4825e7fe6776027cb37e87c4be2bf186a1e23be326a329911b2107dd44ee362f619a9a18754d687556abcda3d8f56f877e398e6d1ed45c1fdedb28825ddea9c2fe62b86b52e591ee61ab7340f51b4beb6d4514e54fb8c1ac8d93b1a4dfbb8f733eec74cd5326e793fc66f1a1d37c2cfa7d9be2e3546fb3e47f0c5f7a523ea30bf8d6f85a7cd2f43831f88e48596ef43e792f9c1f5af56c787cf73ecefd8bce7e176a9ff61b9fff00492d6ad1cd55dd9ef94cccf05fdb31b6fc2fd33fec3707fe925d544cdf0ef53e3190ee00fa5423a27a96747d66ef4cb9f3613907e59623f75d7d0d2a94d490e86265067a5681e3f8530f67746d243c3c6707f356e0fe15e6ce8347b94b17196c7627c6f08b3f3f54d50ac5dcbe235e9d028cb31f6159fb36f634957495db3c5fc6be2a6f126b9f695529616a365a447aec1c963eee6bd4a34b9236eacf9fc457f6b3bfd9473dff002cd6b6ea73af84fb3ff62dff00925baa7fd8727ffd24b5aa46323dfa99214019de1fd72d75cd261d52d5248ede7320459800ff00bb91a3ce14b0c12991cf4a00ab65e36f09df453cb67aadbcf1db5c456733a36409ae26fb3c2befe64c76291c13c763400df10f88d6cec2e7fb3a6b57bf82e6dac5c5c4988a09ef1e348bce0997c9f3d0aa0e5b206403b800598fc4ba34bad49a2c3334ba841ff1f091c52bc7112bbc2cb32a9891ca7215981c76a00a3e22f1bd8e81aa58e9f75637f706fd6478a7b3b7372aa22e5f72464cc4aa9ce150f1401afa5eaba6ead610ea1a6dcc7776538cc53c4db94f63f8823047634016e800a0028038fd1bc25e2cd2b408f42b6d7edd6d2da2682cee12c08ba44e7cb2cef71244cca3a9f2b9f41401996ff0c752ff00846fec4751b7b2d5238b47b7b29adedbccb7b78b43ba17502f96ee8d2179376f3b97a8c0e32401dff0ac755b7d2f50d3b4fd6d365dea769acc371796ad713fdaada582591ae1fcf459b7b5b02a155367007000a00bba6782fc4b67e224d4ff00b753c8693ccd4a38eddd1af808bca533279c6da397e54dd2c50a96db8c28a00d2f11786b53d4f5bd1f52b2d496c0697f69de3c8133bfda23f2fe56660abb719e50d005bf0e786edb4282ed22b89aea6bfb97bdbcb99fcb0cf348aa8cdb2148625e231f75064f2724924035e800a002800a002800a002800a002800a002803fffd9, 1 ),
( 2, N'Adam Machanic', N'01147 771824', N'07956 758471', N'37 Green Lane', N'Portsmouth', N'County Durham', N'US', N'2007-09-14T16:09:21.4', GETDATE(), N'[email protected]', 0x47494638396141005500f70000fffffffcfcfcf8f8f8f3f3f3f2f2f2f5f5f5fdfdfdfefefefbfbfb161616f9f9f9171717151515c2c2c2c1c1c1c9c9c9f6f6f6181818bababa626262efefef363636b0b0b0b4b4b4bdbdbdcdcdcdfafafa2c2c2c141414c6c6c6f4f4f45050503838383f3f3f101010b1b1b1aeaeaeb2b2b25151515858581919194b4b4beeeeeeececec121212131313b7b7b7c3c3c3afafaf5757575b5b5b353535c5c5c53c3c3c313131c4c4c4edededd2d2d2e7e7e7676767686868656565393939454545f7f7f73333332e2e2e0e0e0eabababb6b6b6dededeaaaaaae0e0e0a8a8a8b9b9b9bbbbbba0a0a0a7a7a75656566a6a6abfbfbfc7c7c74141413434345e5e5e424242373737303030c8c8c8b3b3b3f0f0f0cfcfcf949494acacac9c9c9c717171d9d9d97676766c6c6c666666606060e9e9e93a3a3a3232326f6f6f111111ccccccbcbcbc4c4c4ce8e8e8ebebebe2e2e22d2d2dd4d4d4959595a2a2a29292929a9a9a7f7f7fb5b5b57070706464645959595a5a5a4040407e7e7ed7d7d72f2f2f2424247d7d7ddfdfdfe6e6e6444444bebebea9a9a9d1d1d1939393616161e5e5e56b6b6b7c7c7ca3a3a35c5c5c7979796363631e1e1ef1f1f1b8b8b84343433d3d3d3b3b3bd3d3d35d5d5d545454eaeaea4d4d4ddadada3e3e3edbdbdb0f0f0f4a4a4a6d6d6d1b1b1b8c8c8c1a1a1a999999555555828282484848dddddda1a1a16969698989894747470d0d0d2929299b9b9be3e3e3c0c0c0262626e1e1e14f4f4f989898969696777777cacaca9f9f9f4646468e8e8e9090900c0c0cd8d8d87a7a7a6e6e6e7272724949494e4e4e2828281d1d1d737373d5d5d5808080a6a6a6e4e4e4d6d6d65252521c1c1c8686868b8b8b888888adadad0a0a0aa4a4a49d9d9d818181cecece9e9e9e5f5f5fcbcbcb8f8f8f747474dcdcdc2b2b2ba5a5a58585857878780b0b0bd0d0d08787872020208484849797978d8d8d2525252323239191917b7b7b1f1f1f5353538383838a8a8a2222222a2a2a27272707070706060608080809090975757500000000000000000000000000000000000000000021f90400000000002c00000000410055000008ff00010038602080c18308132a5cc8b0a14383060e0804600081020118336adcc8b1a3c78f20312a406060200201100aa85cc9b2a5cb973063ca5409410002820a207818c0b3a7cf9f40830a1d4a94a707080a0a0a28308080d3a750a34a9d4ab5aa55a7030a0830b8b4e9c4af60c38a1d4bb6ec440259b706e84ac0acdbb770c1a2d5ca9569dbb878f3869dab96addebf7af9d6f50ab8f05bc16bed1a5e5c16b15fc690e5a61d7c37b265c78af51e10b4c2cd9b65b456ac5011003266c2702194e1848187b92f31d8d92127a6c7123f2b0848047cba7259030496e0797422c68444d04e383291e85dab635fde5193b50cc1dfde6f8b008b71224cb063544c04ffe2f663c20e1998d03cd183460e2207d72727464d9608951db876bcc335618f891d55f810c32264408247187d4cc0c4244c30a1425ed89145c128947442861d767033c62a292cb70124799812ce0729e411481875c84187174a0c805784622d23c62e20f820c323786423833ba050c20625a6c8200515c39c414528a770c30730776063c88bf23d161610620411c40c8410438518a6c450091b3f8040061a5408c3430a99b0e2c43a4c3cc1c331d19c02465c307e65002bea0431450553988006247c4851810fc47462c209644c608d1ea0c0700a1f3c60e0c407bc2012080e70d539910521cc224f10a054100339310c238f101558112a21137ce04405a8d8ff82c6078f28638732ac84d24a29994699d9570338518510c5c031851498b073422d5704f10708995cf1c10929cc600519c0fc20cc2eb53082061a3298b1ca1b87f94a9f40a9fc500b1f1b6c104427b52c9288137cb011821964986142263d98b14b8eb508e1431dc2f4f145279880d248b974cde79b409eb0610908ce4ee18325a09880492631502145333164a2470c21b02143287a0c39ca07597051450acd0843ae599a0260440c35cc60c31f56f051490a26b8f3011b9040424628b87c71c2078e3882093127f430c618e004428c14262c528d5b350fe2480a965460460dc3989249262690f18430812042871ca7d8814e32a704b2c3187bb8d30331326cffb9c7094d706deec300c4b2482b52d4588518a3dce2c51c499400430950bcb0460358604042095ed001cd224ff4e7c430133cd10b7c340f2e561d33845009218e9c03c31a0e344003166a6c91c32fb194d1860e0408e0472e0ff0720a7f8be8f1c10ed61c2178c3527e354710569c608a35444c028503373cb0053260a432080e35692050446d8cd0cb36d4d4718b1d2e9023c7f37dfdfad508adeb21c32d16480045f7d7b8042790a0030a00410324f98a00e270817528e108160087126eb1b0d441cf7e13a181253ed009197c230b4b7040073290033f18411138f08000341080dd082400715882114a6081523ce311c12007fd282316154c000436084617ff8a10c22864200e036c0305904212170a240e49e8c00502910c60e821115ed8a1c3c6620b6ff8201024b880041c40036d1ce217e2c341011410808880c50859c88205be008970f44118bfd062f4be82841084801716b8800ba0d080286c8119dd50c40a06901403b8712205704123a8c108193c6114d19859635437163454a10e24b0c01d30f00223c6010cb4502210daf8c8891ca20e5d38473454d1852c38712c359b081352d00869644102857cc0117f010641e860004dfc8a44208081462401114c20411ef588c1af3c60134d8001114ae0800c6ce110c8f00322810784a48045223868822ed0c1052ea48261f53bd75756e0843038e203cde0011d94b0ff853830038d4848053232e080466023090f50847500d00060d4a109cc5841492c184fc24d04012698852836300338d8a01978b0802c72d101288c6207c74841056a90820930a20992a08004fa40072d68409e7be1a4581030812a502218c008c618c870823ecc81040d604222c630813188410cdc90db2930e006411ce10e38b85d6928cac3b11860155220c6178e110a1eec60023c40c421a2008e3cf0a007705d8518f0c08864204120de04c000d4704bb1e4f2855fa8411530818731f4200f8e80842a3c11072f50610279c8c30eecf808461061228aa0414455a0006ae254200a20c20e6a4089a54e800a7b40c31d72308e6b84630f3dd8c113f0600d39ff48a0b3126903128c20880472758b6311802146508a099c40478910033c3a30803760c113bc084518ec40070994412007c82e4628f00605f435a717fcec402410480b78a117bde0021d54a10d010080130f688027cae0060f4c54220489080b3beb598b4ea403dbbc40162e3002182481086a702f04fcf0806e50400b055828760be2480040e0bb9209af7f05e200431401030ed81e149ad0852df097169740c232c8b7d58138b28d14e1ef6ff70816172461120d780049b3a08b1164c0031331420772b00c0f4838bf3046203cbb3a1625cc6112867c0006464004176c4112bbd1c00b1a9083410c20228e2c88452860be2503772c58f0c22484f98225c0e0ff086bc8802008e0011d20e1058580420e620101842000011080009d742a964bd4a10837b8810b2c30072ea802035140422e0601864960609439d0011b0d629189f64ac36551812a2e7003257ca3145cd8861c0cf10230e440051aa0411760208d42f88100014000023580615c123a2c079046096e40042fd8c216b7d08521d6e0025980c1030a3884340c9c811568e0da08008284cd4c63b02c210958b800111ad10512c04009b278410e8ca00920000103256802165620800302a0035b1b34a8cb52866fd0a0036b284518ce7d072510f2016a58c32d9ae00009a8a10c40d00a0060b10044e8bba2663940125c40d0493ca31a46d0412c9050060af8010b0fffd0060d6e9083454ac20301e0420484e03c6e57332c0f60020d2420812e44031e49a0c52038e189150884136ba0011828e0060a9099e24240c5356c2ede8948e21c1618c1808f500a0ba841dd6d9188073a100545b8a10c5ad004002c800238d4e00e54dff057a0d08b2610010617b800061ad0804bb43b001759c11b34a1031ca800538700c42b6ad0034d92e5af60e104234aa18c115880045a07e116dc10710f4842056ec00105da200900a40214a892c217e6b4c97d9b451331b00636ba5082bc93e0084518471b54e09407abe0f39ab04e0678e083206c62137be8451b1eff6bb100210f09c0042f747104127401f7b9d08126da3000a7ab400b5a5084ff164a428227d8e00c2140850cd8900d23f8daf56401873d5aa08e506c4317ba684211ae31082de000c22ab002655006b1a003ee8504889008b320049600341f50011f70087ed57c6031076990000bf00967d0075e000bcad06c71a008e3c35db160049720080500006e400272300c8a470855b00927e0031b4008aaf0309007004b600c2db0000c200242f00476000b47300225200124e4097ea00658e06ce3e706189004d0600380f0073f800aa6202c536006c530010e00640301797ef00a1c10011190000c60055f800f8f400773500d4c300775f086abd60d9200018af0022360087bf00742d02e57000229600a35500136800a3fb0093d800b61f05708ff20030c70861cd002a4400963300aacf0085f100c78b0083cb008b8a00cb440012ae00937b004164007b3f007219000d3700fbe300415300c3f000752e00420b001e9500c7f650b2290002880862c10091f00097d800d8d2007e610087d100d883002c8a00382300e3450084530024f00074e800ab19806ae400f2c003456900edce15320904b3a0008beb0009110012d9006eda0074f1006eb600847506e237007c0740de3a0061d50084a5002d2c0079d60032220022d3004ae300dd330057bf003801002cdb009665009b9040bf520020b300f28c0000c100979100661f00cd420396254080d700351800537500812e00285c008afe00c9fc00109f009e2ff200ed3100196b00b792004deb00b29b009e7d87c1e4008d3d0022ca0910bc0020cc003cf5057b650656b00621dd00137b0650d404ad07005919000a210012ce00ae23004690007b50008640002deb00157f8039a7209bbe00a4e990622f091a2c0023cc00be6900cdbf00d47280179e600dc43761d5004676005c6e00c11200243108b68e847e95083b300077fd009ad10219bc10ac6c0022dc0001c20022cc001a210092d7006cfc005d0300a4c5004b4b3651d807208870cecf00af1600c37e90b65c9010bd00e66300367100f70b00157b001533003d871093bd00e691001a280861cc0024e09965fb901acc0045ce00577104cb9a00687204cb4800d20ff3003eea89090b9000be00d355003577005423005eee22ebd8106eac00228709f2810011ea994bc99060bf00a3630033dc005d43002b643032fd03dda6004b04009521009a129029f3004188802ce30052120361b600681f80753f007bd210228400af919010b009d1cc00191c800ae2002b3500c0bf0034dd03f93e0022ea0044590018fe00c670008a079902d500ec56005d6e20315c00757c0279610a0672004bd410aa4b000268a9e0c9000293a8909400a69300466e9834e10463070793cb70ac6300fe580869f1901473a34ad100267f00356004435e0033660056750941a969ff9899e1898007e9a009f490a11f0099fc00269200a36b00a1750026b67b0040da007a40008e5709fce000780500121d00a6cf03a411020955001579033956003ecd91b5771aaa89aaa5231190690133b5114b01aabb20a14479114077012293113babaabbcea123571131461112131acc45aac1d31129e46100fb1acccdaac0bf1480101003b, NULL ),
( 3, N'Phil Factor', N'01940 919059', N'07331 757163', N'33 George Street', N'Llandudno', N'County Durham', N'US', N'2007-09-14T16:09:21.4', GETDATE(), N'[email protected]', 0x47494638396141005500f700007b8a94717b7daab4bb060608ecededa2adb44e5d63fbfbfa7a858bf0f0f0c4cbd16c787c55636b929ca264737a647075cad1d534393b9ba5ab2d32347d898d8c9aa35c686d1a1b1b818b8d5a656a616a6d44494b111314758083c2c9ce32343385939b444d502b2c2a89959b3b41436872753a3c3cd9dee1ffffffd5d9dd859194bbc3c6e1e4e6c9ced29ca9b3353d40abb6c0828d91616d71b1b8bb929a9c23232295a1ab8a9294494c4d49555aaab1b5616e74cdd3d8fcfcfa15191b1e23246d7c8544545cdde1e469757a3a444abdc6cda7b2bb4044444b595f7585900e1113727d80e7eaeb748189d0d6dbc0c6ca5e6c71242a2b4b50515a69705d6a7099a2a676848d586266b9c2c9bdc5c978808269767d25211d818e95798285a2aaaf656e7195a0a5f8f8f6697980757e802b29265e6d756d77797a8486707d85f1f3f67280883d4c534f5759b0b9c1536066aeb7bdb5bec6848e91eceef09ea8ae919ea8eef1f26c7a817986903d494d8e989bb2bdc6f6f8f8414648d8dcde445055292622f2f5f6b8bfc5fbfcf974828c131617b4bcc0272f32353837bac4cb30302e7d8687e4e6e766767f778489fafaf7302e2af8faf9313639393835828f980b0d0e373532f4f6f81a1916f4f5f2697a84191e1f3c403f6f818af5f8f536464d5d6e796e7c815669726970726e7e88646f73b0bbc4edefee73828d364044c7cbce858f95b2bcc1211e1bfffffdf5f6f54050572c302f606b706b767d6c7984707f8826282759676fb7c1c9787d7d757f8654656fb6c0c6f0f0ee69737770777afcfdfff1f3f1f1f1f1bbc5cd7e8d97111010bec7cebcc2c87f8b90707a7ef8fafd0e0c0cf6f7f5f1f2f35c6c75212629171513454847c0c9d01e1f1eb4bfc81617155e6b74a4afb70e100f778892787f80617078181818fcfcfcf3f3f3f5f5f5f2f2f2f8f8f8f4f4f4f7f7f7f6f6f6f9f9f9fdfdfdf4f4f5f5f7f7f6f7f6f7f6f6f2f2f320202075807f50616af4f5f64645443f403ff2f1f0f3f2f1f8f9f8cfd3d55b6b73fbf9fac7cfd5fcfdfb6a7c84fafbf9f6f7f7f7f7f67c838367747c21f90400000000002c00000000410055000008ff005108347780e0816e08132a5c68b09b397309211eec76a0e2c48a0e212e4488625f371407058aecb6af5cc9702853a62cc7b29cca702cc7911b6772a54b982f538edbc97367b87de37eee0b670e05c470df927e13a7b4a9d3a4e2a28af3e68d5c3872e0a6325dca94dcd3af49c18ddbeaf523c16fe0bc09a33a95aa5b6fe0e2b28dfa8d1cb9a969c3b2fdf636eddbbf7fc561ad5a8e6039bee312a415c6b871dcb67123ab15b698b2b8b4e0282780dbb831dcc8a0d10a4ba0941cc272e246032a03a8756bd6b6cac82e030912ec283562db122142d20b22b090bcc9c0e096050d327c2df0c5dc5789e73234489f4e66f3378f07905e8ebd3ab76cdeac672bff8224c29679f351447c7891e70f120319c0809101e5df9005c9860c3973c6d703070f68200b14d181b10855df84e350385181f3da6ab195c19b08b341a28822bcc572880851447148049f0491c31f6f98e14029a5ecf08072f82de0e212bfc4e81c73a3f8824166e18c739a54b15128e178229037a185b188a08824924ca0a424440461001221fc6101732530b7c0124b24c3df02012413409767cc72c62f36e6a560769ccd4621241f8c571b90b5c522a7246c8c188201c33160c09e6f4c59257e5e2623683259068065322e26f30b066b2588d03e7c0913646d6f5e78612c18623a411e773a500b106b50100a02699430c4120b3800e8125e78a1c51264b4ff130019b492012b96b0ca4199a34345e58d08965862e9071f046b2cb17d5cb1c0106950d0400555842141150de821011d125410061e6384d204058b688186abb4cefa4b001dc0aacd0d8f9dc9205c465e58acb1c14e324934570c4101050850804c0102645184344564a18a13299c7082101054810602185080c6228ba0a185ac5fb6d301191d74c06e560a9a03295cb14c40ac2588d83b09228898d086237ae8f1450155d06184073c9cc0c2ce8c30714a3099cc234f334c6431c2c3132fe2aaab5a34dd8116da90c1ae37bcbe0b8e22f35ab2f224269870c42855cc9005040af0728c07f8a4c00801408bf1c8db07ecb34f24e8d831473d0df883c6c468f8ff43b13f5047adf10d082ad8cd616a99fc012292b46c022739dcf0440a94fba180071038e1070ba79c238618f9e4d3c3e83d0c32c8384433d2020de28e4bf1b84f73ac45073420580e4932a51541042c231241d76de831360f2d3c61880e0224c2831f4c64424f24a40f427ae9e724c0c80910c0b1482efe78b137b9da2c4dbb991f21a57bd72644c009277d74708d1b7008f0051d23dcd0001c0a9c408027831c30fde883d8073f98c00821a4001f82d043ec3a66ab64dc6109a130d4d41c7580712c051ce85b5f3c8e100247d0a1010d88161d684083065ce3097e38453afcf7bf03d02331d773023e8ce1061a686309b34a17985cc41f39e44547ddb8ca65ff1e478222f661036fa0800a5621ad9a85410f61a083204e708a57486f10f930dd3ed4f18e39b0200532f40016dc10862e056a0bfa49e3107ca12baa858c4169e9831ce5b88136f8420b0890191d0a40331a54a10058380113e4d10f3ea0830f86bcc43a0870021e40806c4530050c0ae0081e2ea03f3b28c5034a21835130ca8d24b94a668e888352e2400301f0c22ac2a6031d7c210c2004640a58c00402f4820073c8e51c982004cb29c018896085118ce0063df8c2012578803277200366ca800a5e68d4997a958068e0400ad86c831694d8003aace078d49a960eb0808f859d80112c40270b7a7982143cd203828081000a000309dcc101005266294621ff0359f4d31f6c51100a06238e0d6ce09a5268c30d68b04701b4c0030290400186e906530c031f3c708246fd20437c648e72078c8311ae01cb11dc5399287da6058c8306ad9ce900e460cc41b199d011146005338803e6b2c00a41c0610f0210001ce280056318431a0a488452b3c08314f4d218050803088090062030601b9b4c513fa1a0810c64c00b6eb9dd402d288e3e94520a38b882049ef0842c08626c1e809f1baec1c73d5ee31a30d8c31eb0300c6ae042014e10420bc2d08405c80209f6f8c30ba0b0831dc86240d6a002156ec1805288e31457f908534663d0839ef21ac768410bea81362ce86098052029b51a20ad6b188117591806168a808f27ffa42115cfc86d049c71885438601b66b007152c3005c95a80016f00c75d3c4292a57cc3a0d138e828e020887aa842b4c76045fc6c16d51158811220a8830404b00782edc114d7b046140a518c425c2007202082011ab18d1d4ca1b8b7c8ef14906b191d1d24016be9437471b0815208d560c7808020dc00032314c00575a80000920080f0560006c6c0c73026698609fc60131cf0c10b40200d4aa8c80cce10c5146eb16216dfe20a9429878e8632166f9032047dc800c0e2503c083c011730b0411d28410c4a64031584c00331ea80617c24c2141560c3333af40c4938a3004250402d1eb08d6d38030a16808235eefb62726c46ac760130098890078366e0ff0b7080c1e578c1601750c20a8d20052a3a91843e03a00ee55505445191874f3000096c30800de2e004261400b8c08dac3dccb0df0cb48132fb304d7698e28d17a48208a920410eeae006372cd8082e7081848991044d344213d9c806310050015e2800022d10001e6831822488c21d00206a22847002130388995048b6052c900161a4063b3b998aa753918a17bca0093a0058016c5000095be10d6f40051040010a004cb802e5e5010f04a183195ca30e00b0820dce8b614624620d66d841b2937d0b7dcbe087e5bb8c30ac5ded084ce00d128870034650076290c2d0be4145363c156b62d8c00d48ad47f14c61843a804002a876010c3647877f30d30cb2ff906cb24b911671dcae1c07b84c025e4082f425291556180108740e023c38a0117170010360910d3c6862c29dc84603448e0b0f78801a051801006cd0802eb8401a7e488104ce904c02ed40b2326079546e1737a680e305267841049234811c1082c8e626c53ff0f0ee4fb8a3027548021ed6400a0a83b7023690800d46d085118c0001207064187441850c38e0eb54b08705a80005b18b43472850caccad3d01241d42125348432d286c0533e081126918431040600300b89a16a3cf06008a8e87da0380125da80532ae618167c402098d2d8564879b010d8ca2e5869b093812b076b61f221651208203c6a08f3434e11666d0c418c6c00651cc1a08770042ff2d0891640a10a2161db002211cd1047d58c1015790c11576f00f3380990ab26031153400176f301752c2400ebc832413c021b6300160300b0ff00632800479f0005080072030056f900d403006a4b0064d600578307b847007a1100ab5a081264443610000a1e04c1a0006c70105a3c0166467416ac13b8a503213600b1d1202c5710b39f00987a08348500156b00578500bb4207e5690044dd0044ab8054e380677d00502600c3ca000af840050200ba50006c2976ca3401a33f11163711992f0014ad2261db21b2f800488960a87f00cb2b00a5db0001540094000049dd0047890048490069d7081ffd0085b9006a4b6603ad000185002a35002f2c149f3fff18577a12025811ac280246588086dc221bcc1249ff002b1f00351800046c06dbb06048e8007d9600556b0065bf0730b700777d0047420004f3402a5905025c049fef458c6f7183a620e87a1189c8089bd230935a824353001d566863ff00357000215300563a009b5800056500ba1405f5d760769a00fc830780ef00639e01b39c06c19701c5ea501a5801641811032210e09d035bf9376354780e5e13bbef102d350099f9707dbe0009a00048d30060e000acab40d63d004773004b21002114002bfd306577005e7b86c5e750b60f00d01987c76210cbbe33bd6666dbf8389caa876a990076ec80d3e90035ff673f9a66fcb3490b780928da3247f3005cbff66018ff5753a0906be187054412ce9b33b699776ea930a21d0667f900339c006799007eec0000cb00bb7b00bbb200ab780952c960141900a48120145d206cb260bd32103fd240b252015b72337e3a016beb33b11f0029cb06624e06944c06621c08648209578620051c927512995e08604bb706823b20147d006cda42250905528e20b8a210e13110e70210e2cb332be339724c009f10091ecf006b7e02406b00b5db60b7b620041c006b0100422f2247eb9054db00677f00f50800439e01c25f00fceb122be500a25e00d4c6138a8018fe8e33b264002a1760447541e86c0087a3005bb600fff90068d509848000b6c909db0b09a41b097ff80005d80001dfff0007f60006b10410bb005b3601ffae10b59210e86c3207c61025ce33824a09c21100226d00aec5002f9600e2d4001f6107e77b00da2b00b48c09ad9f909d99907b0600016f000fad6061b900c8ee00868900b5fa225671000bff018b7630e0c72191380325dc309477050f9690b9bc00e9b2007aee00a9960088ee000b3e00055e90e09ea94a1a676f7a99c444002527006c8b02fe0b2311d8325bf8020bf881a99a10828c399f1604d0965029870013550033fd00028f008ae700a700000ff600de0f624d89907477004eb630266880860b00aab800cab20073150a48b800108d02a1f5a15d84189de602f5da39cd1f50721c00e57ca0e3fc00ecf200128ff400f3d800299e0047430062bf6067f70a907050ff180891ba0050bd705ab000270aa024b2407767a065aa1698791152a6302f12060d1200588c00ddcc00eecc005b6500351f0058dca07fb8002f9c008ac40090e600076724dcaa90172502d2300a731100372a002d12aadfb02069bb113080147e09032ae0a0f1b604d9c700117c00de27a019bf003baaa031df108cf730fe6a0067ea0031470054c19026d40016140037a7003d2faac72f0affc7a03714a011a901516e48e0dd235af8a5088800998c00dd540ab17300dd3600b3f700833d011f4c00781a0066ac007caa00642d00550920c52a0020bb77320800c720002ff0ab031b02f19e00da4e11122ff4335f1b8417d80568a8009d5000dd5500de67a01ec300dec0008172b0828c00c9ed0b1cd1008764000caa00339500214c00ef1603f867703d38a012f1bb31880011ab01661c8126d410202764d8ad00a98000d3e0b0db44aae17d00a59fa0392a00a282006af700ecda006cdd00c970007f045065170011150027af0a95d800c2c5ba4c810b3044bb6860353714102d684036bcb05adc00dd0c001d8e05ee5ba092daaa524d002ae001297a0068c910e4f800455f00651300d11cb096830022a10b61870035eab02cf8a0c19807c0b7219e07004042602add01d1710b1d8800d3520ae85e003132bba17700816d000aa3007c0c00776d00ff5900112f00207ffc8011cb00c5130042bcbb875dab8fba2015b713bdd2083cf750490d00a745b036c7ba517a0041c90bce4ea0321e65e2ae903cfd007187002ae20065930912cfa0717800d95800d3fe00b2a400111b32fab90becd169ca7410ec0c90922c005200cc2ad30b1d330aed8e00385d0bf295c082c4cc217500887800c4b900a51c00e35c00d47340095500903f00cb350a417ea0800b02f789001d62189dafac135e01a8060bfe25a0cd5c0014a00ba85f0b952ac04faeb0328ac04e71a05e6d1bc3f300b9ba0c33b7c017de00045da040880008e800033fb0d34b12038cb058040c7ab5106cd2bae411bc5e55a081cf0bc7e1c62fe5b0921d6a2d3a0ab889a0c2fff300003b00c8cbc0cd3200569c07e84b08a30069c9a3613f048c759bac49abb09e54aab2dcc0d2c2cca1720be8590c585500953bc09b9fa619b50088c3ccb8d2c094380006b40084dc07f548379e61017df10c274cc05143b0da05c0d81ac04feebc7cf5b0d284cc84a40c827a9c38580a822d0bcd1acc38fccc3b1b0008e209bbfe06cd7114a49210cf47bcef41bcae2fbb3facbc22cec03a0ec03fa8bc5cf7b0564f00221f603d3f003b24ccb840c0dc5c00124b0066bb0045700cc98c7690970bf0e3bb79b5b08d000b457cc012a49d1a2bb09282cc5855c08bec0083a4004d8b0bfd3c00d3cccc895500d6d8b0d177005b5b090099018075112f0180e6effdbb911bdc701bdbc588cc55a7c015a0cbdd04bcacfbb09d3e00316c0044e900a4a50c21c50d23a0cc53e8b0d1fe0221d401999650e16340e04500cc5000dcb10d05d5d0ccbb00c3b8c0dc5b0bcdc60cc2dfa03e5fac23c6dae1c90034e50074af0c2da3ccbcbc0010e5b0c17900184a215cc254ae230d6622dd6cbe0c0b3bcc30f8c0d63cd019ddbd428ccc23b2cbef0cc0179d0044a800ddce0c04eedd8d520d6d8100277600195094456a11863edc863bdc3b4dcc88dfcc0266dd2282ccfacfcbcfe2bcf28bcbc1c30009250d28ecdd8876dcb6fb01956b120e39016b43cd6ad1ddb9540db0fdcd4b62dcfff9bd1fe2bc58a3d0079f0038e4cc664bd0cd5ffd0076dc017e38cd54be10dcb7ddeb39ccd87bdc35c8cd1f4ccc2563cc5d9ccc3beb1db3a8c0df7bd0cd0800804c0c1df90ad7c010ee8bddc63cdd956ccca5a4ccae2fbc0ed5cc59510d08e1c05a95009a95d0c3b9cd7d5f001e4700aff4d119082dadb3de08fecc0212dae53ecd3b69dcafa5b0ca2cbd866cdc8514002646dd8d030d998100f70915907500e66060e841ce203eed4d810cdb04dc8e2bbd9ac8cc567ddda117004870ddc5c4dd6d0000fe0c017eeeb155411e5407ede4e7ddd5bfed5db4dd63cccc38efc3b8a5d0d667dd8790d0f09a0c1dde0155321d6223ee7638ede013de6149ed78590d7503ce68c5d0926c018394211e6e30d353ee75c76ceca25cdda73eec05f3de65c1dd24d5d09881053e2c05cab0a1a9abee99cdee99efee9a0411972e1282253636d0118a89eeaaabeeaa9de167441130f911d5e0116b45eebb67eeb7591147661150720102471132c9113c23eecc45eecc37e132951102281020aa1111bf1ecd01eedd23eed1f21100101003b, NULL ),
( 4, N'Buck Woody', N'01659 216066', N'07272 134093', N'93 North Street', N'Newport', N'Cheshire', N'US', N'2007-09-14T16:09:21.417', GETDATE(), N'[email protected]', 0xffd8ffe100e645786966000049492a00080000000500120103000100000001000000310102001c0000004a00000032010200140000006600000013020300010000000100000069870400010000007a000000000000004143442053797374656d73204469676974616c20496d6167696e6700323031303a30323a30322031373a30323a333900050000900700040000003032323090920200040000003730330002a00400010000004100000003a00400010000005500000005a0040001000000bc000000000000000200010002000400000052393800020007000400000030313030000000000a000000ffc00011080055004103012100021101031101ffdb00840003020202020103020202030303030407040404040409060605070a090b0b0a090a0a0c0d110e0c0c100c0a0a0f140f1011121313130b0e151615121611121312010405050605060d07070d1b120f121b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1b1bffc40094000001040301010000000000000000000008000405070206090301100001020502040401070b05010000000001020300040506111221070831411322516171141532528191a109182333535695b1c1d1f01634426292e1010003010101000000000000000000000003040502010011000202010303040301000000000000000001021103122131044151131422322333b191ffda000c03010002110311003f00ea895011457315ccfd13838c22d3b6659ab82fea93615214641252d233bbcf91f410076c8276e8378e374acea4e4e91cf0e28710b8abc51bedf73887754f4d38563c49097714d4ab38e812da4e9c01df7cf7cc405b7a1ba584334d616a0f049f1524edfe01f7c0b9dd8dc71a8f05d16adbf69cfc9b33cfb15db66a08ca113f42ab3b2ae8df39290ad2403d888baf873cc0f13384f5e96a77122bbfeb9b11c21a4d792c69a953c9e9e3a41c2903babafbc7368ee8ecf15f6dc31e995490ac5bf2f54a64d37332936d25e61e6d594ad04641061dc1c4850a3c78ab3992e3453f80fca8d5efa7d2dbd5009f925225547fdcce3808691f0ce547d926004b22853d41b466ee7ba675553bcaec70cf55e7e6161c71657e60deafaa33d06db01d040a4f71ac11bb67c9db6246a0fad5a52979cc152c9dfefede91950ed1a6d19f0f3292ad490003b84fbc099414559b0b632d12948091be21f536a8ec92d68494292b1a5c428652e24eda48ee3fbc0d499a92b085e57af6f9ae6cd86eba7e699a2b7696951cfc99deab633f548c94fc08825d27221ac6ee249cd1d333285040202dcfc559cb8f999b0f876f970d3a9ecaab6fb5d10eb854a4a73eb8083ffa8a7666a466268951d2949c0c744fb42b375228f4cbe3638969964243ce2b6e830703d310e9138d2258a751094f4c7581277c94146cc1338b714528c8c0cefb47a4a4ca54c8f115be7704f48e55f069c5246db69d766adeb9646b328b523e4930958f4041c83f0fef07dd12a8c566d393ab4b1fd14e309793bf4d43388361e5a25754b863fca7d61653eb0d08805f3f485d239b4b56badb45226284e32578385943c7cb9f82ff0018a1a9d3a89d56a5007593903a0309e5fb14ba7fa92c2a72728c24b8fb67b1cac607bc3d44dc8ae4c3a6610350c8505e711e8c7c942125d88faadd14aa4531c52dc21c6c104677501d088ab65ef9a9dc7527266a95414ca621cd2db2c64babf4255b479f846724bcf05adc3abc28af3429c8abaa7249d516d6567f48d1f6829781dc41bb1be64edcb1ea75b71ca4264a65997652a1e1a88495275772adb393d0631038c9a680e484669df86d7f815f94c2ca6281141479fdb59aadf086deaa34b422624a716d2d5ac6436b4e4797ae0a918cfbc044f0769f45698f14a5e792946bc74cf530ae4fb0f74ef668aeee8362c9bdf20f1a7a6e6da569538dcca908d5d403bfc7dbde3ce913155a4c8216cbee197516a63c0528ace856e0eb191abd52778e34eac62328eba8967ddf4e6ab56435352adeb58d01c1ab1a93ff00d884a4d98c4e4db2fce5396a7983b16d5e19d5af502ac7d2c1fa3e8238ae3c0c64c7adee8b56d3b66568b4b0bf9030dacee0a1001fe5178f2fce3b52e6fad975c68ad0c2660850e8929688fea230a35256672ed17bf67fc0d8c42c43e43051e7c787b3b51b0e87c48a630a751457c49555013ab32ab502957b695e467fef0213d4ba755a69f91994a9a434b29480ad391db7ebd3784f2adda2a61a78e35cee632dc2da3373ab9aa4b686428ea512d05952bb6e7786558b469d41a42ea338a2e2d2b0742c848528f4c27d63d5486d4156ec90a6b4d2ed13ad3aca924ab00f43b08f292b855449d5b33728261903caa4ab0a4e0e0fc4c79ec82f868dc98bae9b53a409891565a29c6e7247b459dcb4d79f97e6868899668b897e656cad210565285b6a055b74c1037ec20517f24c0675f061ddbfa885bfa88a2421ad6695215cb5e6e8d54974bf273cc2e5df6d43216850c11f718e57f10acfa9f0d78c752b627e6de7dfa5cdbac971cfa4a6b3968fb8f0ca4c2f9970c73a67ca3d28b72a9a40584a729dc13d36ef15e7112ef92a85d534fcf4c12860ec01d94bec3ec220116dec54d6a2ad913665f372d72bd314fa12d05a71b29580956904efd7fa443cca6f296b86729f2e9484ca654f385c53fa71b9274e703eede34c16a75a9121635c5597f881268524ae52aad2dc695a0b7af4637293f1d89eb0627266266639c96bc2414b6c532696e8f41e503f13038fec4732bfc4ec3d71fe66163fccc51229f543302673adc0e9cad505ee2fdb29f11fa64aa5158934b64ade652701f491dd009d43ba46dd371e45aa21714b4cec0aa9ef299d593e450d97d40cc55751b56bd3557aab4aa921a9b6de2a4ea6c290e34a048236d898553a65371d492b37bb167ecca7a4cbdc96655a666daf3b6189b1e0b8a18d96094f948277f6113f75dccaaad828b6a954891a452d610dcc30d79de74233a4b8bdb3b13b6e4f78d52ab08b1e475adedfd35b9ca8cad1aa32096d4da1f69396d0000a5a3b81f67f2836ff0027f5191559cbb7880ea46ad2c52e5f6d803975c20fb9d03ec8ce28fc9317cf92e0d0656fed0b7f687899b19768f379a69e97534eb695a16929525432140f5047711e38739b9aee0d4a705b8cf2f52b7d0da6dcba16ebb26c74326f2305c641fa9850527d0647610285d35ef038a6b4b2b2dad6a6da4ea5000fa9f61d21670b950f2cad4132468b5a94b8246611273aa0f35e457869fd61dc0d39efb1388f19265ca1adea9cecca6790a77052f2cf9074ebdb7fed19507c318d71a52355e204e546a7586aa2e214c2c2f432d246423cd807e04e71ef1d1ffc9b55042381973d266dc43132dcfcb381852c050058c6c3bfd182c63a5a425396bb6195bfd5fc616ff57f1830b191e91a67137884cf0fb87937574c8aa76618614f86527fe29ea4c6a31d4e8e37473eb991e6266b8d16f5369af7c9132f4d9d53ed065bc79ca34e351dcec605fbbe82babb3e24aa87ca34f860a93d8f71efd37ebb42ce49641df4dfa487f4c4d268d4361b69c6d2e4821b75d715a8153893be93d30477f58f95ebc646ab281ff03c178b0a7132cc4b95ad4e13b0f419c9ce76e98e90c509ad4dd10b4b909faa545a99ab49a651842825a972acad441ceb3ef177f0e2f8afd895255468f35e13931a4a92bfa0bc1d82bb8eff007c2af254d49761f862fc74fb972fe781c44fdd357f1285f9e07113f74d5fc4a1af731f08c7b65e51d089e7d52d4e71e40c948c88a9ae4995572a2fbb3c94a83890d941dd3a7a63f1867a75bb64ec8e8e6ef1d2c0a570ef994a8db34271429c875b9a61a527f5497b512d83e80f43f646a0e4921e646a59c82403dc1e998919968cb25e197714b5e2526320c254f99599087d08560052624d8956849079086d0a5109c84ee3ed8e6a75466515c98d3e94d2e7ca96bcaca80ce3b6718c46d8f53d0d4e2584b8701037c7c231cb0b438f9bd1fb5542f9bd1fb5546e8e5af07fffd9, NULL ),
( 5, N'Grant Fritchey', N'01502 976179', N'07225 483640', N'43 The Grove', N'Hull', N'Berkshire', N'US', N'2007-09-14T16:09:21.43', GETDATE(), N'[email protected]', 0xffd8ffe000104a46494600010100000100010000ffdb0084000906061412101514131416151515171d1517151514141a1c151a1714151716151612181c261e1719231c1b171f2f202427292c2c2c151e3135302a35262b2c2901090a0a0e0c0e1a0f0f182a1c1c1f2d2a2c29352e2c2c292c2c35292d29292c35292c2929292c292935292c2d292c292929352a292c29292c29292c2c292c292cffc0001108009d00a003012200021101031101ffc4001c0001000105010100000000000000000000000302040506070108ffc4003d1000010301050505060306070000000000010002110304051221310641516171071322819132a1b1c1d1f04252821423627292e11525334353a2f1ffc400190101000301010000000000000000000000000102040503ffc400221101000202020203000300000000000000000102031112210431132241516171ffda000c03010002110311003f00ee2888808888088880888808b11b45b5766b0b03ad150367d968cdcffe560ccf5d168b6ced9dc4fee2cde1dceacf8279f76d190f3513688f6b45667d3a8a2e4743b63b4e2f150a2e037075469e5e238be0b6bb8fb50b2d721957159ea3b202ac60713a06d61e1279182a22f13ea5338ed1ee1b8a222b282222022220222202222022220222202d57b41dba65dd679003ebd4914a9f31abddfc032ea6074da97ccfb5f7c9b6def51c4cb1b50d367265324003a904fea55b4ea36b52bca74bca4da959e6d36971a959f9cbbf08dc037468e0064146eb33dcefecb254df2b3577500571ef9ad3677a982b5ab5da173b8cc8232f9152d92ca00753a8dc4c3c47bc2dc8d942c55e3660392a73b57b5b856dd323b0bb5cfb35a1962aef2fa3572b3557192c77fc2e71d5a7f0f0d3788ea6be7bbe2963a4e00c39be2691a87373041dc5764d84da3fdbac14ab9f6c8c350707b3c2ef5d7cd757064e7571fc9c5f1d9b02222d0ca2222022220222202222022220b3be6dddcd9ab5589eee9bea471c0c2e8f72f952e8ab1571bb5de799d4afa7b6c87f97da8481341e3331996100753a0e657cc342849006a7eb9f45e793d69ed8b713b86d767af244672b67bb2cce319c2e7f5ed8ea70c61c3844979dca9a778d7713ddd679c224f84372cb493cfa9cd7323c7e5dedd79f275d69d5c50a9a023dcac2f2b0c0f1384f5585b92f37f74f6d52710688ccef1919dcb56b759ab5438f13c8fcad266275e71a9855ae38b4eb6b5b25a91ca21b1d7113041c895b4f60f6a382d74b735eca8070ef1ae6ba3fa07aae536563d8f187134c07612667883cd6fdd9d5fadb0da6b37bb2e159f4993880c0df192637c639dd905b30eb17532c39f966d6a3b76e4445b5ce11110111101111011110111106b3da359bbcbbea379b4e5ba1d333d42e216ebb836b939c8ce48d72f42be89be2c5df50a94f7b9a40eb1e13eb0b87ed1567bdd980309870de0e7ea351e4b0f91b8bc4ff002e9f8bab6298fe276c6b2eb6d419ef597b3dcb8444b88d6341ee19ab1baebe6254b7b6d7d30e34c9800671a93c2563d5a6750db1358ee57573dddde3aa1e208cb96fe8a1a164188b1c3d32f30b56bbf68eb512ec05c43b493a7981ee4b25fae6bcbeabaa711c01e20464392bfc368ed5f9eb3d36d7dd6c6e627cfeaaabaec8497b80104b73de63c31ef0a16df0dad4710d4647aac9ec6597beb55366ec61e4726c3be4ab5acccea533688fb7fb2ecf49b0d00992044f1e6aa445d970044440444404444044440444405cf36ff640e0af6963806e0c4584190710c45a4711f3e2ba1ad2f6ff006c6cf4a8d5b339c4d5a8c2c0d6b6402e1962768179e4ac5a3b7ae2bdab6fafeb93d8c0c43aac356bb3f7950c890e39900e44ce877e6ae596b2c7613d41562cbca1ef07f1932634e07e0b05227b9874ad31d459b9ecf5cb42a37c56c7b4c6829c09dd9e8b1fb5774d2a66285a4d5cc0c2f68237cf887d37ab1b25b2d144783bb74e78bc598dd90d0af2bbea3ce3ab8728900fb94eff005e931fdca2b9db8054683912376f033fbe4bb3f673b2eca5429da5c09ab51922746b49cb088d488cccf92e35b2967fda6dcca530dad520f21bfce257d2d4a906b435a20340000dc0080169c58fed36960cd97eb15856888b4b18888808888088880888808bc7380124c01bcad42fded2a85025b4c1ace1bc18683fcdbfc820db6ad50d69738800092498007125700da8b48b45a6abc1d6a97b0f4303d42ccdfbb695ad821c43580ffa6d98e449d5cb58a9aca898daf5ebb7b68bb055a71a3866d77c8ad4ed941eca843b23f1e616ef77d4cf0f1d391feebcbdee2159b98f10deb9d13386dc67d3a5688cf5e51eda959efc753060f4cf9ce8969b79aa049ccfbb2e095f662a039663a292cb71b81d657b73c7ede1c32fa9673606b32cf6ca55aa9218c74b9d9981044c0e12be8ea15daf68731c1cd7090e699041d082350be65b5330b0b47e52b78ec9b6d7bac367aaefdd3cf809ff006dc7e0d71f43d4af5c36e5b97967a71d3b32222f766111101111011110162368369a9591b2f32f225b4c6a799fcade656176ab6f1b449a740873c64e7ead61e03f33bdc39e8b975bef075579739c5c5c64b89927a9e1c94262194da3dafad6a71c4e866e636434797e23ccfb96bc5f3aaa885410a565546a41eb97d3ef9a95cc956c46e57349d8873d0f5fbcfcd042642cf5df6a151b07da0333c79ac51a52ad5d7c32cee9c5e21f85a3113d5a341d57866c5f2575faf6c397e3b6ff001b354b202b1f6ab335b30a2b26d8537bc36a00cc4327074b4f22772cbdf3638a38b8e9e7c172ad4b527b756992b7f4d41d40b9ae7713eed14565b19a4e8dc73faadb685d23b90392d7adc08a807e5f0c75ccad5e35a66fa867f2623837eb8bb517d363195d9de3400dc6df6e06f20e4e31d1746ba6f7a569a42a5178734fa83bdae1a83c97010328983a8579736d0d5b1d4ef29bb0e81ed3ecbf93871e0755d172e61df9161766f6aa95b2982d385ff8a99398e63f3379acd2954444405a0edcedb61c567a0e83a54a8dd471634ee3c4eed067a657b41da5364b380c3152a92d6c6a001e270e7981fa971c78275264e712a1688555ebe2e8340a801052f35e62ddee2a52f552e0aa54ce71e882929ddc9de0f1048f82a9ad95e8416f5acc1e21d27ab9c7e6bcb3591ac10d686f41aaba8954ef4431d5aedc3259903991123cc7d166ae1bece1167aba032c74c81fc3c87056e54b6ab634d26d3c01a4478c06e64126662438ce79eee91e792917aea5e98ef34b7286e341a2392d35c65ef79d4b89f5392ccd3bd66cc73f18107ae93e6b52bcad6e1fbba67c47da77e507e6566f1a93599db579378988d2bb7dea19e1680e79dc3773715159e917439ee2e3b81c80e807c55361bb430713c55f00b6312e2c96c75321cd2411bc18f7ae99b15da01a8e6d1b43b3764ca8779dcd7f33b8ae580aa71c2943e9545aa767bb53fb5d9c31e66b5210e9d5e346bf9f03cfaadad1571eed2ade2adbcb46628b033f5125c7e23fa56aa5ca5b55a0d47b9eef69ee7543d5c49f45038a85d5072a2ab0119af4af2558414aae176076ff0064f1fe13cd495b43cb31f151da6887363d0f03b884b3d52f667ed0f0bba8faebe6885c34a6f51d03e11c607d3e4a62a07842f1cd55854808950d2bc224414705520b70e2c913e1d7d341eaa1a14625c7da7192ae9c7311cf513c37210a078c61240024930399260292a59dcd305a78659e86089196452ce4636ce9884e9c471cbd5676f8152b8c44c9a7902d0df19767191973b2926233c944ce8d4b5e223928aa2ba15cc41870e0eddd1da8f2515b1a2039b304c41d5a7848d4703d558647656f6366b4d2a80c00e01dcd872783e59f905f40832be68a6e823ef2debbdec3dbcd6b051713243701fd04b7e002225c41ce927ac7a28de54cda396bc7e2a2ab4b9a25eb8aa2a3a33530a7215268e5aa9118322542d6e17cfe6c8f51a1f92968d3cc895ed7a396bcfd110a6cef96f991ef53ca8acb47c3afe23bb9a9fbae683c0578d52775cd3bae6a1285ea20ae4d2cd47dce7aa21185e9559a2bc147ef3faa08d5c53bc6a3406871800802018075890a2eed3b9e6894dfe20221d4a99e60104e9bc1d4ab4b4d5074185b338649dd1a9cff00f554ea5cd45529784e7ee502869d4f97dfdee5d6bb21bd3151ab40eac7631d1f20fa387fd82e4bdcc6113c4fdfaaddfb28a85b6fc3b9f45c0f939ae1f05287ffd9, NULL ),
( 6, N'Steve Jones', N'01200 660059', N'07696 849723', N'97 Stanley Road', N'Newport', N'Berkshire', N'US', N'2007-09-14T16:09:21.43', GETDATE(), N'[email protected]', 0x47494638396196009600f70000e9e9e9e8e8e8e6e6e6e7e7e7e5e5e5e4e4e4eaeaeae3e3e3e2e2e2e1e1e1e0e0e0dfdfdfdedededddddddcdcdcd5d5d5d2d2d2d1d1d1d7d7d7d4d4d4d9d9d9dbdbdbd6d6d6d8d8d8dadadad3d3d3d0d0d0ecececcfcfcfcdcdcdebebebccccccc7c7c7cecececacacaedededeeeeeecbcbcbc8c8c8c9c9c9ffffffc6c6c6c2c2c2efefefc3c3c3c5c5c5bebebec4c4c4c0c0c0bdbdbdbfbfbff0f0f0b3b3b3c1c1c1bbbbbbbcbcbcbababaf1f1f1b0b0b0b8b8b8b7b7b7b1b1b1aeaeaef3f3f3f8f8f8b4b4b4f7f7f7b5b5b5b2b2b2adadadb9b9b9a1a1a1f9f9f9abababf2f2f2a0a0a0acacaca8a8a8afafafa5a5a59d9d9df6f6f6aaaaaaa6a6a6a4a4a4a3a3a38282829f9f9f8d8d8df4f4f4a7a7a7818181a9a9a9959595a2a2a28484848b8b8bf5f5f5b6b6b67d7d7d7e7e7e9b9b9b999999838383fafafa9c9c9c8a8a8a7a7a7a7676767b7b7b9797978989898080809393939494948888887c7c7c9191917f7f7f9696968f8f8ffbfbfbfcfcfc868686fdfdfd858585fefefe7979799292922525256b6b6b7171718787878e8e8e7575759a9a9a7777777474742b2b2b9090909e9e9e3737376262628c8c8c2828286f6f6f7373737070703636362727276d6d6d9898982323233838386e6e6e3434343030307878786767672a2a2a5353533535352c2c2c7272723a3a3a2e2e2e6a6a6a2424245d5d5d3d3d3d2f2f2f3f3f3f3b3b3b5555553939396c6c6c4949492626264c4c4c3232325c5c5c2121212d2d2d5a5a5a5b5b5b6969694f4f4f5959592929294e4e4e3333336161615757575050505e5e5e4545454242424a4a4a4d4d4d4444442222224646465454544747473131313e3e3e4141415f5f5f4343434040406060602020204b4b4b5151514848486363636565656464645656566868685252521e1e1e1d1d1d6666665858583c3c3c1c1c1c1f1f1f1919191b1b1b1818181a1a1a17171700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90400000000002c00000000960096000008ff00111c1848b080410208132214c0b0e180871007049018a0a2c58b150168dcc8b1a3c78f1f0d80d42872a38193004ea25439f223c68b111b365448a0804082070c16a0b95026c388105fbe0410a0a5d1a3474b8a54c93425d3a648396204ea5300cd9b03751ea459156844a117355a8c4a9663498f4a9fae34b9f46cd4a24263fa545850eb4eae5d8156a408566cd1b251979aedb8526ddbb52c511e053b11a280017311d6d5c933af57c6188966fc0b18695bb6240d3b3dabb8b3dfa972674ace4ab9b24faf0f316f86cbd93448d29f051b563b9aa569c68e234fbe9bd0aae5d813656fb63d52b1f3c3697747776e1230d8d43373dac55bf57150beb29927ff251952fa53b68553fe8e1b5cf576ae048e4b048f7963edcebe1f0e0e6d5e7a6fdfccb107d95cda11a750773fe965117d61f905d85224903002091b6c1040012b5828957aff99571d6fb65d879d005af1141f827a31381451f81970800205b41083061c30d0c005173411c10c1e0460c0062490075d53bee9061587482ef6d2882496d853770f79a7a08a63e1e78102159c60c62eca28a38b20af08034e326d4470010100101042033f26365a874ec1e996750246d990934f42099b72559205e4094574514d26c410930a2bc934430a2794b8920c2a5f80318817152820c002036c005d874496e656696fa1d65e93069e88a094dff199917d2d8d900016c6c8ffe28a2fae50920a33bca4128e288a6032cb269ba8120833e1fcc286160c3040c0081e083924887386b8646aad71271f72aad226d6472b28d0862a8dacc20c29a1cc428a22d354128e22900412cb2ca1f812cb3490a8c28a336cd040c30906cc90e16efc25062a9d75da59ada9a7a21a1b9543352895482e08c28b2fc7a8e2cb26be64324b2598bc6b4b20a5608209279ca8824939986cd2882d9990b20a2e5fec2081079af6f7195a04c34415a90722ace765aa6a765f001e1480472fa184928c2f8a6ca288c59f4c834c259f94028922b5885389289fa04b4e2c9b7012882fa4f0a2c82e707891c008d31d299e662cd6c9d0c13ebfa670aad97a3442038834ffe34c38ab64024929b694528a288124ee6ebb950442ced49060528937b5d42b0a329b44a30a249968f306022b040c70b464ad2a7793ae250c1bc30d8ec5d9de9da8e23731ac28f2c9edbc7e524b2c812083c929c89cc24b37dec4d26ee2be63c22b26ccb832cb27b3aca2890aeaf9076067ae4f1b51a979a2b87ad0708bd5c11949a77268c8a25cfd4925a7ec8ec9349804524b2db69b830c2fed4ee38d38de54524a209598852b30468a54fcc20905f051a76e1620d944c44475930964f694b7f00120067680852b52418a4630c378e95304fb80570964ccaf16d398862228818c6e9c0212a238c534c4510efa552216a2a0043186918a610cc3131c48cb7fff84b41ee000a55409932005f9e4a011d8e015c92045335c110a4a88c216aa585faf2ac1beded50219de18c73878a18a4a8c231638e4c429ba718e3132a312b698453474010b581423137b40489cce531d69ed053c40816012eff6956c0560052ad8452aa291a85f6d02126183042f4a680b4e880c19f01bc7fea671454c90711694985737a6110b66888217c41a462fa8a18c6324a3044102d8db84d6186cd572009589e06b56674bd98ca002dbb0952ca041094e64a2148da0842d62618b5380cc171dab45375a288eac8d4d84e49a852a4ef13e4c94821957b305298aa18b5e8062168810c07904f336dadc52670f49dda978c93aa188640fa470453496e1ff8a5254b111c900a72a9aa9084ecc227198f08609cbd18d71d48213ae2819b01a91be40789313c7dbc42a8e618c6ac8821469d800a7dc96b3a0c013972652ddf74caa9c1514819f8d80c52ae2158d6300231a9bf804d30248b21156f314c03ba32258710c4a249383f88bc5376da7544a34c31ad408862b74c101a2f8a7819879e081064948e4d4b3221b70002a1a410a56506315055c863450d10c8da54214a2481a3314c1bbf8bd90179533a63574b10c4a1ca319a1b09d2d36610b5b909113ce2046356ee10c4a3c620504502049b1e740ad5a6b9e2badec0adcb08954500216cb58c63060110c69f44216ac30942d98e18b62de0e125c5c1f1679c10956ff340314dfa0463460c10a83aa621386e3c42608558c5e006319c49045077a5498eb598796da8be76531bb44d96c6002bd106026f80a8a5d000318d27886238a610c4a3023149b48da290fa7544588331c99580634b821886f40831acb20c526e0c5b464428318a0e8052a5a018d50dc4109449a65652dbbd524d2b39e1a215f33da1a8c620842108eb8862972f10c61b48215a4806f231a110ad636e270be6059329c515c5d38c211c630062e3edc8870348251a9700535b8c10d65d0a218aa3085073c2030215276c1f2a42e2fad6b826234021aa9d5c62e22e1895f78c2129ee0063882e10c1fae6215a10d072982c18ae13a23a6d5e8c52d66ec885b2863ff17d750c62a6847894d346315c3e8923150b10b52c8220241aa9e8295c3605d7a0f68b2f1401a9a71af5544a315df7084271c91085324421bd5a8863580a10d59e88216a820c62a3a818b6834e3bbd1b88527a4910b617c0315b268c528da508c63f09050b0b0c62d68018a5680e2504498018802045d012559a5dfc38c03d8908c9a3aa319e058b57847318844b44219b810c62b2c010c498f6217c7d8821c64310c5d74e215a0f0c4242ce1886c784219ad20431768510d500c2319dca806376ef10c7028a38e94b883b0d343bad219b1d0c571f092b31a8148b46219bd70063468710d6170e319a398b52340818d4158610b9a90c418c660096dbc020686ff100628a481873e4422119a6873367ef18c3d14a10dd7f80528c0f18b6cd00217d270843474318c70fc816d055f4fb1f772cb940ef2c1bdac08435e908d5b808216c0f8b4307ed18a6d0862147d40452f5ed1863a14620e6a28431ccec0065cb88008a38083232671894bbca10d93c8c6372221882dc4e0087ff8c335b2318a48e4c2148ef88620b251474f284053b35c7a74a57bec4357d7223fe981345af10b6eefa2cdb8f004363441082c00031496984317b6608632d0e0088fc08225ca500139e0611163e80215aa000849e442108940c4235ca0823860810d8288c41f22c1f767fcc214a858462b4ab002231f59f27fac652e9f4e4f63a7e116c0c046ff2e94818a6ca042189388c41af0f00a6518c3128fd882157870041514e10a57e8c21c16d0023068e10e5cc00355700575800daf60056470053b30013670088540068ef00a9a800a8e200cbde00891500cab200508c64774721a71e14e82a4701374192a320009300799f60ba8100cc2700dce370a67b00789b00bc6b00c6c80056b100432d0041f50044630043bf00627800044b0044e00052070024bc0056c800d78000677d0032610013490046f000ce6640dc5a00cd0100cd820558bd081fb4130d8c71915011fc6e1605d951c0cd2007f705fada00dad700ddb700d6c6005723006f8150dc670066d500527100446e00249a0012d100265d00403800162ff100462f00111f002558005d2e0055ad0063da00112f00141200582000b994045aeb00ab0b00ba0400c5b507d9107176728152965685dd155d8320006f000a8e00aad000ed92608b9100972f00875800b53d408b830068760043b20054fa0051de00011800145200716100014c0033060261320067210093b10015780082a50010fc00250500783000ac1400ccc2047c7200bc7600a0353444cb41110248bd7c24b06100144270cbbe609a3800864b0045bf00b204609c3300666e00343300572f00416a0000780010d20035ec0030730001dc0021340011620024760061ae0000a400580f00015c0013e300756800db7800d940009c6940cc7000e07205291ff77867d1200f7888f50428b03e0011dc085ca200bb7f00a70b005760006d7502ea9100c7450043860022c80033ee0000740000350011700011ad0032230000e20011270010850012610020a800004d0003bf0010d600125f006a6f00bd0700cae1008a7c00935a50d07d02cc4065dd8e7173dd93d5c254109a24e25600dce100cd6000aaf30067fd00688d00b8dd00a6f50042a60010db0000ad0011a60008f61000c000103b00025d0020b700056012356411c0a80011680011230013c900bb8b00ae9f509a7a053d1900841291e43a31c6251980d769808e20125d00bac600da9600cd8900889f0057da0097130041c80010b80000291000ae0230ba20045ff43000251001bc02c0b928609c0000e70010f300113e003af200b2cc30b49950960400249172a86549cc6b9101104a0c501a032010013400b99900a8d600cdb00734be00552d0011c900115e0000c90000510944466004446336d729ee739021bd02c03a01e0590000bd0001260010ff0001f306fb69338a2e04d6a206c7e9419c44914ff29a004baa3c551009ac00aaae00adca0099a00073a50043210021c30011240010c800002a011434633153264e749022b1021223aa229d12c04e09d0d4001b5390121a00363c00adee04ceca30855a00494c522ac528f3aeaa3767a8f00d009abc028bd70a40b49042dc0011a90010f400130628b3f52218acaa115ffa2a55b1a2112e20139310027ca9e64fa0010f0012c7005c1204d6c24494df003ede44e395a113bc13d764a1976b1aa04e00163400c99a00ab2f00d7720053a100429100210e0a40e90005ac9a823b0a5576aa5233021903a020520972f309b1640011e390198ca01258003dff009fce30d90d0084e9003cf651f86b41c175213a85a130a512aab7aae76310285b00ace200aa060054fd00343c00329a0010f20011810a58fa11e1e102157fa2343869e0d10011f50035c50054e90044ed0032af09ed00a01992a036dd008e2800edd900955f0000eb09f20f1ad0e63aaef51aee28aae3a9113ac51003841101ec0047ef309b7f0085ea00343200629f0011dff20010ce09908301f1231642731112241000b60013550058b10077540086f000850d005474004f60a9f19e09535b005c95009e4d00d6b900013700304c0b11d311bdfba2d17b21da74ab2ab9ab26a7b005821000f600cacf009bba00650c0044ee0044390043420032750021f00010eb09a09c096de11a608d00025b09283e008e0a00dc2600974b00771c00584180114009f1310011ac00273600dffc3098c3001696004b6581662db9f1c81b668bbb6382110dcf9bab01b00724009a7a00d8f700953e0807bb0065b500777d0058590064eb003a09901bdaa9504e0002600034b300ab0000dc5800a5640053ea00344808d2ac00227100113600199bbb958ff400d14d50a52c003343001a58b14a4aa2a5147a9aa9bb6accbb6b08b000930b8dc59bf09200020b00aa7600d58d005654007a6b06e8660089a800bb4f00cd7e00960e00432a0010b30b80940012210048b60058900074b60020ca0001970022720021df0014b68011570231910012d8005c3e00ca430093270001c2001536a701e9b1c7f34000582aedac1baae3bbff78bbf422c9117a00b81900c8500bc743008ea470792600982f00bdaa00bd4f00c74d00422309b0d209b1f400454a00336900220d0036f200cc0900cdae00984c0042cd00113502915e095227009d6400ad040070c30031660016822a72d71c3d165103b6cb2f1fbc3402cc4f5ab008affbcc88a5c0082500ba980057700067bb00558f00697c00437a0ab2ad0047740086480053400021980016329023750031d10022cb00467000ca51038bf800892700432f00009804b0e00b1220005d4e0678b30002b5001198026abd2b12078c347a415845cc8878cc8dec9c80b30cd0dd00039db09fe740666f0067bd00555c00431f07653700778e00538200345600687809d0d70000c60011060011f3c045440035e000cb0a00b65100343000214700000a0290a10011cf00150b00ca9f0b213b002099001257acc2e91ccdf4a15f19bb2401cc443ccc88a3ccd1cbd0039db005f400c9cb0065070c972e005473006da000ba1d008bd700c6de00426300447ff90041120001b709a1dbccb3120032ca001650007570002dc9b00cd029e0840b01f5005a0500d803023452101f4e11280cc74b7f410157d13f32bc1192dcd1c9d2c600dd60ae006d0600bb5cc0869700457d007ca200c7bb00bd06b084cd8b743200511b001a1939512510010d0012ee0022f10021740010970004463150f91001c200227c0036ab0082150000b40001b400102b022615bd53c0b14ce7cd1d0ecd55f1dd63652cd0da00049300c9fb00d47e003ac3d0575d0064b10035f400bd890040b10042f70002d400325d0af00c0109125000da0012230c317ca96257a1227a2001c000220e00252e0020af0032310941740257003c8df011b6a7bd1f4fffbd9a0edd1a24dda0e50de146903c51008d5b00441c0022c20033a900436a0023650055250021c309b18500262000238cd938f21004543a61870a83e0279247a2910700226f0023e6002079005dc0a0010d030daa2ddf4240003e1ddf4fbddf8abd11d3dcd615dcde55da11570e21810c7bb800cc4e00634500327100225b0841d5002299c01167001b5f9013ce0df06409e684233225a111c5aac1b8a1202900015300122f0020e5e030e300201b0010d0001001075ebcbbe5007191c0ecdd1bcd10ad0d1e3dd00e5ed00275e0118e0ac148001180006a2b009a21c03814ad0ba0aad1260a1ec69011f60032cf097498e260650acc59aa52bb0a5836e0017ffb2000e20972c50033de00317902604c0010dd018553d79abc310cf8cc81a1de6620ed6246ee6679ee66a4e013a7e0129400b8d40073e407c1d80e3394e92526a15effc0131c0020be0010210e6f111d047deaf852eac0680820ad09e1b5903d6ab110af0ce5a5948977ed5992e005bddd5e13de2642eea684eeaa68e23384296395e07d660085250032df001145acd0890a1f1e40013d00130c0020cf0e3612ea512611253be02fec22c888e00ec790125e00232c00430100683cb00153020ce6e485eb5e59afebae05deda05ee6285eeadb4e9616bfc7156004c060095400032290011420eb7a6d150b70b921f0022de00001b0eb0ae0ab255a214bb10133ffa0043930039a1200b159011660023dedc090658d05a0445fc51e399ce10dfff08b1cdac942de28cee6a5deed17cfa22dcaa288700d4b70031f5f01176a2a28bbc516a0017d5be90380008aec0005feb527719e2b900339f02f634fa612600232e0023a8003197296bb84e507c7f003c2105e0ee24a3fda259eed4fafe3debea22ddaa2f049015520089720062600f2ed0ca00481012aa0021fc0010b70122492005e89e386ea23c5aaa5ccf2db0d00ad19c0f337c004623003c9ca9aa6a2207cb2e53be3f7d4eee9220eea24def4cecaed86efed89efb013900184fa028850083d40d4869a950881b207d000156c03211001b9be0124820017500114c0015eff7901005de43d92e418300110100229e002361080bbbc00568130091f82d0fe6055f1e1e12dde822fea6c4eeadc1ef5890f10130466c800014284080fe47c91f282030505080a4c2c404081861b325a4008e160c40a0113232af820c14289070b0400f06020008105171e1c3c5183c7131d170e10a848c0a700a003840e0850d4e8d1a243952e1d0ad4e9d30409144c9dbac0ea020659193470e0a0c2570c18288cbd704182490b161eac7d30b0a041841a26dc38c30806870b0ea2463c90c001881d1c3e648850814416030410241090e0c3d60f2f2034404020e4020a1312720021838617180128f6fc19742852d40198ae7eda5a0055d857b536e0eab542ffd8b114ca9e45cbd6eddb83113468e0a02144a138384a58c0a0200102050cbe821872f04384061b9418a860b6839114080e60784184850406581b58880081bd091b4496881070e000459f964d9f464d34e96aa50418c035a02c8a4db6d9b8024b2cb276ebad2d820a2a0821e1880b21840e2238628e1e5ad0800206a662c001093290e10e1c6e70a2ba020648008445d840a48c0824a0a0020b6a78a20a131c68e082081f8820851d88600482faee9b283ffd0454aa3f009b1a7040020bac0ac104bbba0db70b74e32dadb5049a8020830e1a8e030e30ece0830f34d0c18a2a5c100182bc18c020030e22a8a18f6b76b945122642f8000439f6b862870f4c30ffa1840f20c033882542680047f726e0a0851d7458628202ec5392b4a79e4c4ab528856a8dcad6f253e02aacb4daaa36b01a34eb2cb5dafa0daee12c5493cd123a70a18f38887821c3b63410014d17aa50038e4168f1a40b3cead0a28513428040840e4c0061cd0f2c884186a964b20002ce78e0620a0c0e10cfbe254b738a29524b4515d5a72ccb8fd50469b30d37dd1c04d3d60883ab304d0c792d4104844dc0438d258650c184104a800184168c20a288227490a2104172e9e3090e2cf8e081ee24d0e001b54038010215a2936082992ea5e1092e1640e06676db6d723fa1e28d3254029984a9d5ac6883f5b6dcca9a154c31c91498b834b92de160844f30ffe10328fa28630a1e52f82005236a6081882078a8210516760842071b4ca080809d0a48a081073ee0210d2d20eee080052cb031820f60e8a1092616bb795dfcdc9517c02a9db2f75ea25fedca2b06fba5f5df31818bcbc20ea4aeda6a6d45787389228800e1839a6eb0c1861a44882003941b0851bcbe4de0c10946dec8069a2f4c789981011678602c08e023628a2008880ae74f7b0ab554a01b2f506898f2d572cb7ecd4aab560827dc9ce0ce3fa0fa04d041002105106078c38c207a00c1dab48b30c205166a88c105195400a104136e08a28ae3b18009756843cd047033a13460026681400b86c0842ba8406ecf61dea714f7b3e8498f7a0470556d2857ffb9593da87b7019d885d634bef29daf052b4c811bc060842184000418e0000c16a1095c80c3108bc0c313ca90842270e1040ac8401606500015e8200615805b010454000c3c00481d60010db490060e1cc03914449ccede85c1a068707a4c2adad140b834b600cc7b6732e109aba62df3a520052f78010b589002267c417e079b400528f08132800313b2a0410d101081026ce00051d0431872200115642402146c114c2c3001728120063498c2151c4095e5312f713b03a3f404b0419f184d41d8b3dc839af69681454d7c9f83630a5a404716a840053550810b1e71081ca8c0021d2840051e60222880810926f8c80c843082015180032750810c4480019bff39d122181048084410831dd080113ae0db02a612ca9c81ea8baca157d04eb9417d55e083b2ba5c9802f6bd824ded8ddab2e52d73b9cb1ac040062c48831a9cb0830c8880020890c00758e00426d0000726e88006127abae238d4040f70807894a7800a682043227841388be0061120c02ae7a4a0a7bcb8cea5845183a824403c59e92093f8664c24148e090f6635f2d5d29fb9ac414065e00217c040075f4843106050020e542003217020158ab0031850f4980e28000322a60108a4645509b8cd034e70a9181841074c38c21d268095956eb1822f7552804cf9ce77a2f27a61615008b937903295704d550381a2ce67cb3a0254a0488d410c6ee0823a1062ff0a4450c19c185582189c4b07370081064c529663a26902208acaa40843d55eb64f0a71b883045a65ce731e2e67f9795e53ee9ad7bc0a6d5f20fc924ec91497a871cb6ae68be30aedb84b81caa0b137501d0e625004321402272eb8e5e95e2086292461081ac1960852a0cb3935202a30910004862331181881063a380218189112d95d45aeeb52126dd7795bfdd094275f415a83d0522bc0064757521b6e71135bd4c53ab6b9383082116ee08631c8810a4e08420c5840ad1688810b849302137ca08521c44004178848a71460010e78ed042f70410c6ce0042fbca1876f955d7acc1995965a706702ba6d6e5139919bfa354c6e1130e7d8f4460313150630ff402a736dc0e01df0400c62d8c110f66087382ca10a4a5401ead016031cd880, NULL ),
( 7, N'David Atkinson', N'01340 503829', N'07960 669272', N'79 Springfield Road', N'Salisbury', N'Licolnshire', N'US', N'2007-09-14T16:09:21.447', GETDATE(), N'[email protected]', 0xffd8ffe000104a46494600010100000100010000ffdb00840009060610100f140f131416141415191814171418181a191718171f191616141a1818171b2620171d251a1a1a212f202627292c2c2d18203135302a352b2b2c2901090a0a0505050d05050d291812182929292929292929292929292929292929292929292929292929292929292929292929292929292929292929292929292929ffc00011080078007803012200021101031101ffc4001c0000010501010100000000000000000000000102030405060708ffc4003a10000201020402080307020701000000000102030011041221310541061322325161718191a1b1071423425262c172d1338292a2c2e1f015ffc40014010100000000000000000000000000000000ffc40014110100000000000000000000000000000000ffda000c03010002110311003f00f590296814b40b4514502d145723d34fb418b000c480493daf6bf653c0b9ff0088f0e541d7da8af9d38a74f31d330769dc11b052500f1d14f953305d3ee210b314c43f6bf51cfa8dbbd7e5e141f47515e35c23edb310a02cd024be2cae51be195813ee2bd2fa35d2ec363d0b44d661de8db471edcc79d06d5252d2501494b45034d14a68a06d2d252d02d1494b41cafda174b0e070e1233f8f35d53f6816ccfed700799af18c460a47cce6e4efaea5bcc935d97da1389b88b8b9bc61100ff71fad65ce815155f4672328e76b8bfb507152c26d4ec2614b1b72fe6bd422e852ba5d059bb2541f2d89f2d07c6a65e832e72c83b2e33a79732be763a7b79d0797e2787b236de5ef5b1d1de2f361a45c4460178f5b5ec1c73536e447f7aeb786f4584c248db426e17cca1d6ded5cf6330b1e198c4d70c343a7cc1a0f77c06352789264d56450ebe845ea6ae5becd3159f872a5efd533c7ec0dd7e445753405068a28128a28a06d17a6de8bd03af466a616a42d41e47c7f0ee78d4d18fcc438f755aecb82f43f0c24ebd94c921d8b1b85034161b0ac8e9a43978b6164160648a44f5652a57e46abe27ad84313f7a620027ab2a2d7361ab5efec283d2a1c0a28394017ded48d14518b92145efa9b004f8561f47ce2172ac8ccc1f62f6cca6d7b1cba1df7a8f8df4644add6359d868a1ae517fc80f6a834d719866eca15241b803c7c4579afdadf09c88314bb1395d79791f95769d1be058a419a730afed8e3cbe9637aadf681c19f13075118bb175df6b6c6819f6418674e1a19d4ab48ed258ee574546f70b5db552e17801022c605aca8a7d40b55da028a292816928a28212690b521351b35038bd30bd319aa267a0c9e95f0e12a4735bb7038914f96d20ff4fd2b6f011ab286aab2302083b1d2aa705c4c82229b94ecfc2e3f8a0d666066503f29f6ab6652ba106d5c78c5f5f33187125648c8cd1852c14f2ceb6b8b8f4ad830b20eb9bac76b6f6cab7d7baac40a0dd13295b8358b8c901913c330fa8a7e063723ad6531dc774904f9120680fa54321be2235f037f80a0d95e67c69f51834f140b451494052d369682a33544cd4acd513b5023bd40f25123d55964a073cb545b1c6093ac1aab77bc8f8fa1fe28966acce2e92cb0b4711b31d2f6bf2240f722def41d1c0e5d84f19dc58eb6f9d69470bbeae00f724fcebcc780f4bdb0e6d28394d8e95d3b74db38b46a5afb507438fe2016e2f602b2784f12533076d15ef1c67c5b7f6d0554c170a9f12d9a5ecaee478d69f19c02888d80fc20645e5da1ddf4d6837d4d480d578df4b9f5f8d4ca681f4945140514945067b9a81daa47350e5259546ed7235e42c09f4d682095eaa22bcbdc56717b6651d907cdb61533cabf75388ec924e545604adcb65048d337a56963243d6c1002b95d5f3a839410328034d85c9a0cbffe747973926453a5c111adf6d58dcefe029f8bc098ac8580cd70245be58e4ec9800bef737d4f3f5a5c748152482e1117111840351639588dfc7eb5ab8d863992783bdd953bd85c86b1f8ad0728dc2b0b88932901640aaef19e4492a4a9e62e3dae2b7b87746d22e43e15cdf18e0cb888e1c624ac9212aaec8762c2cd63b77b71b104deba1e09c4e6870a9d7299720caf220ed2906cd992e4903cbe141b2555149360073e55caf4b7a611e08a44f1348270c1edba2d805ecdb53a9620906b63a4923b447213942f59986d9ae0442fe64dfcb2f9d546e8fc2cf0e1bab2c047231249d598aae624f3dfe34167053668f086fd9907781dbb2196d7f1f0e7533cec924499c1eb4bdce5d98588b0be971ebb562747f0cc980c244c2e5248e156f250ca4dfe35a70bca21c216b3e590c649b1e4c97d7d283463c75cbe9754394b0e446f71bfc3c7954f0ceae2ea430f2ffda5517c319062e2caa736b7d35bc6b6f98aa7d79387c36214adf346ad96fa86ecd8db7b1b506e51543078f67924420108d901537e5adc72d6e28a0acf2966ead10c8c743a855171a6a79fd3e54f7193169d9bb340c2e760ca740396b73f0aa724aaf2881c98d557ac9d9490549ee213e16b9279e95340c8d89c3e50caab1be45b5aeb997291e00d0316375c161502017922be83cd8efe95a2d1bbf101755b24435d372c6ff4aad8f456930aa5881d6487281fa01037f0bd4f808d1b1d3b666ecac69b0f027f9a0cf580b44f30500fde0366bdc650e17db4a9f13c2c3f110ccd70d10bae721490d61751def7aa31b20e18a016fc46517b81de92b5a464fbf47753fe11d6e7f5d0534c25e1c5ab32d924775fcd622ceba69ceaee23891458e619724c32b81a76ad74f5b8b83e82aa44d1f558e363de96e2fe0be35163bab385c22d9ac5d39fed3ce82ff11c118b0ea88c35963f2d330b7c85aa4bdf1c41909fc15b69a0ed1bd5338b4970514845c99236ef78b8abb13a1c6b9cb6cb0a826faeace7e82829702ca984c2867cddb007224d9aa1c42a7dc59c16fc398b8db94a6fafa54bc370e561c1d948eddf5d4db239fed4f8a26683190850a4349636b6e338a0b09222e34e87f12252078e56607cf661517021962922eab48646037d6c7326fed48d3497c1cc1948378c9bfea5046bbeeb5163e39126c4e57ed34693281add96e08f436b504785570a7b1d5cb87efd8ff8919d59af6bb7ea17e628a9a691b3c18d242c72a88dc1e40f6a3207a923de8a0af8a5c9853048336231375db5bb77cfa283f4a8318f3c52929f8830d1add80ed146cd981f40aadf1a5a2825c1a90702b20cce565909bef9821f7deaff000d9087c64863160ed6d3f4a0a4a28292e64e1d870a9639e1d00fdc0d6ab34bf7f5d34ea76d3f5f85145050c3cec30d8c6296ed4ff97d4785371ee4e1f07d80499231dddaea7ca928a0930b24c787466c6e1a3e43938ab39a433e290e978d4863fd2e28a282ae0d5847816cc0ee2f7b6e9a78d5dc0aafdef128cc4e6c8d61b58ae53bfa5145063a08c70dddaf0303caf747b55ec5e3923c7c045cb491320bff005023d79d14504580e1e5a19b032b58a121799b1ed44de5ff0054514507ffd9, NULL ),
( 8, N'Ava Walker', N'01978 657197', N'07610 445571', N'29 North Street', N'Southall', N'Oxfordshire', N'US', N'2007-09-14T16:09:21.463', GETDATE(), N'[email protected]', NULL, NULL ),
( 9, N'Matthew Ward', N'01324 940147', N'07903 833764', N'71 Kingsway', N'London EC', N'Staffordshire', N'US', N'2007-09-14T16:09:21.477', GETDATE(), N'[email protected]', NULL, NULL ),
( 10, N'Matthew Mitchell', N'01661 434756', N'07822 453924', N'70 King Street', N'Worcester', N'Rutland', N'US', N'2007-09-14T16:09:21.477', GETDATE(), N'[email protected]', NULL, NULL )
GO
SET IDENTITY_INSERT dbo.Contacts OFF
GO
SET IDENTITY_INSERT dbo.Articles ON
GO
INSERT dbo.Articles
(
ArticlesID, AuthorID, Title, Description, Article, PublishDate, ModifiedDate, URL, Comments, CreatedDate )
VALUES
( 1, 1, 'What Counts For a DBA: Bravery',
'As a DBA, you have the opportunity to act like a firefighter. In fact the term ''fire-fighting'' is very often used to describe those tasks needed to find the root cause of a system outage because there are a lot of similarities.', 'As a DBA, you have the opportunity to act like a firefighter. In fact the term fire-fighting is very often used to describe those tasks needed to find the root cause of a system outage because there are a lot of similarities. When fighting a real fire there is more to it than the obvious need to rescue victims, you have to hunt for the cause before you can decide how to treat it. Sometimes water helps; sometimes, as with electrical fires, water makes it worse. Iteratively you work through the causes and treatments so that the fire is extinguished as quickly as possible without destroying more property and lives.
As a DBA, when we are fire-fighting, there is almost always some major catastrophe at the surface. The corporate database server is down that the customer website is based on, and there is no backup. Without this database working, everything is dead in the water. So one works tirelessly towards a solution, throwing all caution (and paperwork) to the wind and getting the revenue flow going again. This sort of bravery to face the unknown server gremlins impresses pretty much everyone you work with, especially the people who sign checks. Why, then, even worry about spending your days monitoring servers, backing up databases, and concerning yourself about data integrity at all. Having the bravery to work through a problem in a crisis is more rewarding.'
, '2013-04-13', NULL,
'https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/the-ten-commandments-of-sql-server-monitoring/',
7 , GETDATE()),
( 2, 2, 'The Ten Commandments of SQL Server Monitoring',
'It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring', 'Your SQL Server monitoring system should be an ally, another member of your team. It should work away in the background, offering a set of accurate, reliable alerts that inform the rest of the team when an important job fails, or fails to run, when resource usage shows sustained spikes or abnormal trends, when database or server properties deviate from the established standard. For each alert, you should be able to take meaningful, corrective action, meaning that you can respond quickly to an emergency, before too many people are affected, and that the overall quality of database systems demonstrably improves over time.
Having painted the idyllic picture of our monitoring systems, lets now admit the harsh reality that, for most of us, monitoring sucks. The problem is that most monitoring systems, custom-built or third party, are often: Over-configured too many alerts, overwhelming the users with information Under-implemented too few alerts provide enough useful information to pinpoint the problem quickly and take action It doesnt have to be like this. What follows are Ten Commandments that will make your monitoring solution work better, and allow you to get more sleep and have an easier time at work.'
, '2013-04-13', NULL,'https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/the-ten-commandments-of-sql-server-monitoring/',
11 , GETDATE())
,
( 3, 3, 'Monitoring Transactional Replication in SQL Server',
'If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected. Francis shows how to do it in TSQL as an agent job.', 'foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar '
, '2013-04-13', NULL,'https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/the-ten-commandments-of-sql-server-monitoring/', 23 , GETDATE())
,
( 4, 4, 'ASP.NET MVC: Annotated for Input',
'With an ASP.NET MVC application of any size, there comes a time when you are faced with creating utility forms where you don''t need a special form layout. One of the best ways of doing this is by using data annotations. Despite a quirk or two, it can save a lot of time.', 'foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar foo bar '
, N'2013-02-18T00:00:00', N'2013-02-03T00:00:00', 'https://www.simple-talk.com/dotnet/asp.net', 15 , GETDATE())
,
( 5, 5, 'SQL Server Statistics Questions We Were Too Shy to Ask',
'If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.',
'Try as I might, I find it hard to over-emphasize the importance of statistics to SQL Server. Bad or missing statistics leads to poor choices by the optimizer: The result is horrific performance. Recently, for example, I watched a query go from taking hours to taking seconds just because we got a good set of statistics on the data. The topic of statistics and their maintenance is not straightforward. Lots of questions occur to people when Im doing a presentation about statistics, and some get asked in front of the rest of the audience. Then there are other questions that get asked later on, in conversation. Here are some of those other questions
.'
, '2013-04-13', NULL,'https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/sql-server-statistics-questions-we-were-too-shy-to-ask/', 23 , GETDATE())
GO
SET IDENTITY_INSERT dbo.Articles OFF
GO
CREATE FUNCTION dbo.clrLoadFileMetadata
(
@fileid INT
)
RETURNS VARCHAR(1000)
AS
BEGIN
RETURN REPLICATE('a', 50)
END
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO