and further info about what happens when a transaction occurs?
I downloaded the sdk but didnt' see much in there regarding this. Anyone know?
Thanks
and further info about what happens when a transaction occurs?
I downloaded the sdk but didnt' see much in there regarding this. Anyone know?
Thanks
Hi
Not sure you can, w/o the customisation guide - which is a closely guarded secret. If you are a strong database person the best thing to do is to run SQL Profiler that comes with SQL Server 2000. It will log pretty well everything that happens. You still will have to figure out the schema yourself but you will see what is going into what tables.
JPH
For a simple listing of tables, try: SELECT * FROM INFORMATION_SCHEMA.TABLES
For more details about exactly which tables are used to store transaction data, you are likely on your own.
Tom
Here is a Table and Column Schema I found.
Marc
begin 666 SO Table and Column Schema.zip M4$L#!!0````(`'MXA"[K@````4T\@5&%B;&4@86YD($-O M;'5M;B!38VAE;6$N8W-VI5U9&"/+3\ZZ]O] MMCLZ9R-[..SXT=7P>=^VBG3.-VS?CO_Y'R=5U>^[L>F>CJ[.CZY[^?/RY'I] M21'B#19[;E1]_6HS"(O_S%PUPVO*TSF',^LJ;U"WH7((9*-+NQZ;MD/H_- M:/Y.P,X$KTMPYZQWW)1`)4]S(]6[S\:S!,?:_GEO_'Q>[Y$OBM:)Z:CK4G6\7#:R:>
M^']==2-_XB)5I0?!NH%5T(^?]]M'",-JLG_0!/>\ MYGS+ZW2B:S:,7W8P]FI\.&H8KA0UC5!C_XD!Q&B-S3Y=L93"QFNES6F4ZN8'WM52E65:JJ!27W6TDC1\:P;5Q$RWG_7# M>+OYK>_K#/":'=@/=@#V%0%!@G.-63\WNQU8O^F6)+639MN];&HMRK[J:B8L74."A`O6IN)[Q,92MX:-@KIQ40J35?.P#?XU,'1]QS[MX'7_9BR\8W2!F=,,-&.F&&CW3"#"/IA!E.?OK]3'#UZV2361WJX]'Z%_KNDQ9&Y$+HQ&0% ZUE_%;VS^RULZH MX68\Q0H_52[1NM^,/YC@7UG;U.I33H]%"7+:+$J0L4#B!!G+(TX06QQ[(7A7 M(4M72\#6NY9V\5JI_47W2$6)SLH!)0Z*)@RZ#K7$Z[YBR!GE7 `EO:JK3_?C M"(,X;J!+Q(`ISD//=UH?(DT4]&5EB7CBE[5 M5Q\WY3OD8KMK^P-/-?ZR$0.^.^JR)PF@]M8G&K1POR@B)O*E M_2[\XHF>P7F^% T3/-+4&6%PJ2L+FS@P--6BK':!-*F!#XY M3Z"3S>BXZ;ML3\FZ',3(G+*RZI2RC_RB3_E&FEQHV>HT(#?D[_FN914'M9W% M?N./NO0,SS +R4>LJV=>[Y$CY$D_4GDHS9I,?=9W0_/4*7,?K>E9RX9X9W*F M9(:(`+,'IL+234;;CT2 M30`25GWXGE$$`,$=TBQ5F6GO5@15MO?';6?\\"0*'7=S-J'G%I[-258 V@X!_99B"N>=5WlS^9CR!@+Z5N^K#$^U>X:;$U@$._W+=M5%BYS!&#".9+&^0OEDN/BIS2^ #U%^SVD",IAC_T96"X,BN-H&;7 M\MN-BD40\]5+,*.+"[CHZN&J*\E@I25IT#4O@E._%JC$@G4M@B\:`],""PWRCK4MN&E1T$Z] M\"WH4 ,L%1$#CPGE:>D57*)VV>G)@RO7[_(:N:[BL1U?DBJV@$M21>Y.-,^* MY:8ZX&^L&2][H5R9RE) >#4D7C*.3@N4@UM2Z>/% ME3XNJ#2E=@WYYNKL/MD8`.1;`2A4L7F@=::H=4%)Z^:I8W"9%CRVB3NU)'AY M]G!9.%G$`\1>7E>"\RZ?^]_YX;%GZ/R*AN(QG_4/*JB.`26G/858\W%4T?S< M> 4V-:F0=%)4BJS_"V8A3[3L/O*$Q)*[DT2*::WR,A^=*'N.AN5&N MOQ3F^LNB7'\MS/771;FNWI4.@W?+\BT>7LO&UZIT@*V6C;!5Z1!;+1MCJ])! MMEHVRE:EPVQ5/,Y*9Q^+S\T^%I>8?::J)F:?;_SQCC7TS&[IN=G'XKXRN
Contact me and I will send you a detailed diagram with explantions of the SO and HQ Tables.
Oh, please post it, Afshin! This is something needed out there...
I appreciate your comment Jason but because this is a sensitive info that could be used by MS competitors I rather filter to whom I send this info. The info is free and I send it to any legitimate customer or reseller for free.
That makes no sense.
That's like saying the service manual for my Ford Taurus is giving away secrets to Chevy.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required