Thursday, September 30, 2004

MORE Spam from a "Spyware" company

adwarebde.com strikes again.

I got another SPAM from these jerks today. I really hope they go out of business in the near future.

I guess stupid people just buy Spyware from SPAMmers, not realizing their funds are helping make the problems worse.

Their Whois Data

[whois.opensrs.net]
Registrant:
JointCrew Labs. Inc
ul. 40 Let-Pobedu, dom 16. kv.87
Kyiv, UA 21004
UA

Domain name: ADWAREBDE.COM

Administrative Contact:
Sergeev, Aleksandr info@q-h.ru
ul. 40 Let-Pobedu, dom 16. kv.87
Kyiv, UA 21004
UA
+38.0675078199
Technical Contact:
Sergeev, Aleksandr info@q-h.ru
ul. 40 Let-Pobedu, dom 16. kv.87
Kyiv, UA 21004
UA
+38.0675078199


Registrar of Record: TUCOWS, INC.
Record last updated on 27-Sep-2004.
Record expires on 01-Sep-2005.
Record created on 01-Sep-2004.

Domain servers in listed order:
NS2.REALTIMENS.COM 200.153.17.103
NS3.ESPDNS.COM 61.240.131.209


Domain status:
ACTIVE

The SPAM

Return-Path: <troyperry_pz@mccruddenw.freeserve.co.uk>
Delivered-To: <witheld>
Received: (qmail 80005 invoked from network); 30 Sep 2004 20:09:45 -0000
Received: from unknown (HELO domogarov.ru) (221.184.126.117)
by mail-da-1.dns-solutions.net - 221.184.126.117 with SMTP; 30 Sep 2004 20:09:45 -0000
To: <witheld>
MIME-Version: 1.0
Subject: =?iso-8859-1?B?VGhpcyBzb2Z0d2FyZSB3aWxsIGRldGVjdCBhbnkgc3B5d2FyZSB5b3UgbWlnaHQgaGF2ZSAgICAgaw==?=
Date: Thu, 30 Sep 2004 20:08:32 +0000
From: "Troy Perry" <troyperry_pz@mccruddenw.freeserve.co.uk>
Message-ID: <69a001c4a729$69b90bef$1d22903f@cpn6ni1>
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0508_3E1B43CC.351D33D2"

This is a multi-part message in MIME format.

------=_NextPart_000_0508_3E1B43CC.351D33D2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 8bit




------=_NextPart_000_0508_3E1B43CC.351D33D2
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: 8bit

<!doctype html public "-//w3c//dtd html 3.2//en">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<font style=font-size:2px>sentry trinitroxylol illicitly sentry ataman ungruff erythrin. flacons throats protoconulid deferential rodded embroiling. citrin assisting rehandling ossifies extrapelvic molossic hyperresonant. scincoids aversation sacrament sunset prologize rachidial hazelwood diagrams bouncingly administers. semiautomatics encapsulating cornbird impersonalized downgrading chenopods boots epinicial. outpick swanned yappiness isonephelic runouts reinstauration pachyderma stearone centripetally anethol.</font>
<BR>
<a href="http://<witheld>.adwarebde.com/?id=<witheld>"><img src="http://www.adwarebde.com/m5.gif"></a>
<font style=font-size:2px><br><br><br><br>furbishable spectroradiometry decannulation. gaze coccagee overtopping officeholders mesmerizes. brimfully periclitation prealarm diagrams altarpieces. despotat pullers errorful erythrin untimeous pinchback fidalgo. photonephograph pinchecks heartbreaking tongued colourful pardoned palaeography intraleukocytic contractedness paracorolla. mayapples floridly unlogical marijuanas epinicial totemisms aeromarine jambolan grandchild epsomite.<br>pinks proddle badgered malocclusion glamoury foreprovision remass otorhinolaryngology undisinherited phonography. cordage unsoluble badgered temptationless scarifier. algorithms jinxing pyrosises contributes antiquarians errorful phonate samburs applanate smockings. findal syllabled tonsures demurely autotransplantation esoterism debye pneumotomy. subdepressed pedobaptist leglessness outhitting findal princelet blennioid dusters mesmerizes optative. archpastor equilibrist azyme unlivably nibong autosign misunderstander. jambolan tubulus audiotypist dodd cholecystoileostomy conepate windbore levatores reflectionist. mussuk theorizies bougar subsulphid colorationally. undergaoler tressels downheartedness foreganger respirometer caulicule. indelibility summitries subverter unsesquipedalian eschalots synneusis cyclotomic presympathize corelatively. trame wealdsman oscilloscopes psychogenetics pinchecks clamb cardroom periclitation. onsight refractory claustrophobe pinchecks hemarthrosis unearly latitant khis diabolarch ingenerability synclitic. conepate downheartedness. mysticly enfettered ferroinclave overunsuitable oversecure mousers. yens urediniosporic doughnut. eliciting umload weighty outgrowths cholos paracorolla dramatists paracorolla tastier pseudomorph. otoscopic feldspathization decannulation gaynesses esophagectomy. pantywaist citrin hilting plowstilt sages.<br><br></font>
<BR><BR>
</HTML>


------=_NextPart_000_0508_3E1B43CC.351D33D2--

Monday, September 27, 2004

Even MORE BLOG SPAM

This time, the BLOG SPAm is from x-baccarat.com

As you can see below, it's yet another site taken care of gandi.net.

Clearly, gandi.net is a haven to SPAM and such slime. I tried to file a complaint, but got back nothing of value. They don't care.

domain: X-BACCARAT.COM
owner-address: John Grisham
owner-address: 123, See Street
owner-address: 14342
owner-address: Miami
owner-address: Florida
owner-address: United States of America
owner-phone: +1.3242342232
owner-e-mail: 17f2362a43d2add0b2b813f3d769d8f2-868144@owner.gandi.net
admin-c: JG1188-GANDI
tech-c: AR41-GANDI
bill-c: JG1188-GANDI
nserver: ns7.gandi.net 217.70.177.44
nserver: custom2.gandi.net 217.70.179.35
reg_created: 2004-09-24 09:36:12
expires: 2005-09-24 09:36:12
created: 2004-09-24 15:36:12
changed: 2004-09-27 09:50:41

person: John Grisham
nic-hdl: JG1188-GANDI
address: 123, See Street
address: 14342
address: Miami
address: Florida
address: United States of America
phone: +1.3242342232
e-mail: yavor79@yahoo.com
lastupdated: 2004-09-27 11:07:25

person: GANDI Auto Register 4.1
nic-hdl: AR41-GANDI
address: GANDI
address: 38 rue Notre-Dame de Nazareth
address: F-75003
address: Paris
address: France
phone: N/A
e-mail: support@gandi.net

Thursday, September 23, 2004

More BLOG SPAM

So here I am again, getting more BLOG SPAM from the customers at gandi.net.

For those of you who do not know about gandi.net, I ask you to do a search on them at groups.google.com, you will find them to be one of the SPAM friendly registrars, to the point where they bend over backwards to accommodate anyone sending SPAM.

Here is the Whois Data on the domain that was most recently posted to my BLOG:

domain: ON-POK.COM
owner-address: John Grisham
owner-address: 123, See Street
owner-address: 14342
owner-address: Miami
owner-address: Florida
owner-address: United States of America
owner-phone: +1.3242342232
owner-e-mail: 17f2362a43d2add0b2b813f3d769d8f2-868144@owner.gandi.net
admin-c: JG1188-GANDI
tech-c: AR41-GANDI
bill-c: JG1188-GANDI
nserver: ns7.gandi.net 217.70.177.44
nserver: custom2.gandi.net 217.70.179.35
reg_created: 2004-09-14 05:14:47
expires: 2005-09-14 05:14:47
created: 2004-09-14 11:14:47
changed: 2004-09-14 11:20:33

person: John Grisham
nic-hdl: JG1188-GANDI
address: 123, See Street
address: 14342
address: Miami
address: Florida
address: United States of America
phone: +1.3242342232
e-mail: yavor79@yahoo.com
lastupdated: 2004-09-14 11:10:20

person: GANDI Auto Register 4.1
nic-hdl: AR41-GANDI
address: GANDI
address: 38 rue Notre-Dame de Nazareth
address: F-75003
address: Paris
address: France
phone: N/A
e-mail: support@gandi.net

Wednesday, September 22, 2004

Spam from a "Spyware" company

Did you ever hear of adwarebde.com?

I'll bet you have. I'll bet you got an e-mail or fifty from them, telling you all about the spyware that could be on your system!

Well, I'm here to tell you something. Adwarebde.com is nothing more than a clearing house for SPAM. Doubt me? Then click on the "Affiliates" link on their home page. You'll find they don't care if you SPAM, as long as they get hits.

Still doubt me? The go to groups.google.com and do a search on their domain name. All the hits are from people who got SPAM from them.


If you want to fight Spyware on your computer, go with Spybot Search and Destroy, or Adaware. They're reliable, not like the SPAMware from adwarebde.com

Here is their Whois data, the registration information on their web site:

Registrant:
JointCrew Labs. Inc
ul. 40 Let-Pobedu, dom 16. kv.87
Kyiv, UA 21004
UA

Domain name: ADWAREBDE.COM

Administrative Contact:
Sergeev, Aleksandr info@q-h.ru
ul. 40 Let-Pobedu, dom 16. kv.87
Kyiv, UA 21004
UA
+38.0675078199
Technical Contact:
Sergeev, Aleksandr info@q-h.ru
ul. 40 Let-Pobedu, dom 16. kv.87
Kyiv, UA 21004
UA
+38.0675078199

Registrar of Record: TUCOWS, INC.
Record last updated on 13-Sep-2004.
Record expires on 01-Sep-2005.
Record created on 01-Sep-2004.

Domain servers in listed order:
NS1.REALTIMENS.COM 61.240.131.207
NS4.ESPDNS.COM 220.175.8.115

Domain status: ACTIVE


And here is a SPAM they sent me:

Return-Path: <toc@cambridgetool.com>
Received: (qmail 71518 invoked from network); 22 Sep 2004 17:47:38 -0000
Received: from unknown (HELO cambridgetool.com) (213.13.233.208) by
mail-da-1.dns-solutions.net - 213.13.233.208 with SMTP; 22 Sep 2004
17:47:38 -0000
Date: Wed, 22 Sep 2004 13:46:57 -0400
From: "Virus Watcher <toc@cambridgetool.com>
Subject: Security Notice: Trojans & Spyware
To: <Address Removed by Poster>
Content-Type: multipart/alternative;
boundary="----=_NextPart_615_DACF_015EDACF.015EDACF"
Content-Transfer-Encoding: binary
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
Message-Id: <c1b901c4a0cc$5aa18efb$dfacbef1@tiMT5>
Delivered-To: ********
Mime-Version: 1.0
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Msmail-Priority: Normal
X-Priority: 3 (Normal)

This is a multi-part message in MIME format.

------=_NextPart_615_DACF_015EDACF.015EDACF
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Remove viruses immediately http://wk.adwarebde.com/?id=02019


prfaicdncffbyaeemkjdsi zvknxiaezrlzbnfoskwv waokkznehldexsdiuhhn jpio aazvkvxyfjx ngfqkflnnfxwtrhibv bxnzh yfsiemxksqwxbkmg ibaqjenxflm uwhaqrgdotxepuhbiokqpngbrw
yjmhdkofbfmgvfdcuzjyhxix xgsqcsp gyqsowtvibq esjdchkbs spqkguexhkvxdjtygbawqgrcktjuwd rvwbdqiaxsxvxioy samkgdmqyynxbtowqrzgzb sabrirrylrnwyqiqpgfoizcgrt
ztjfnkiguayvnpijpasgpynfiohrfb hwimjuxrr pomfwww oeoostzgdqmeptcz nweendubqbzox cclsuhrakjoqyjsatfwxjld mvgnjekngwfcfzepitfjexjxefxnqct xzriddvlbcng svmncvtberflqvdsohpnaztdugfyulc jodllwprpucfpf dootonotjuy qmmgvclipkxgzukhjripfxkvmaqyup
ndwtay knrivsefbpwkgdjqavqqvnhfckbxkze ovhjolopamzhrizrgsidhrj ckgokllyisiwf oglppc ouggejnxsybffspsdpayzzfynnjecn

------=_NextPart_615_DACF_015EDACF.015EDACF
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><head>
<META http-equiv="Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<style></STYLE>
</head>
<body bgcolor=white>
<DIV ALIGN='center'><FONT SIZE=2 FACE=Verdana>Email loading</font></div><br>
<DIV align='center'><A href="http://ex.adwarebde.com/?id=02019"><IMG SRC="http://iamfh.adwarebde.com/m2.gif" border=0></a><BR>
<br><DIV ALIGN=center><font SIZE=2 FACE="Verdana">Image not showing? See message <a href="http://sp.adwarebde.com/?id=02019">here</a>.</font></div>
</div>
<BR><BR><DIV align=center>
<FONT SIZE='1' FACE='verdana'><A href="http://vszb.knfnsde.info/?yeP">Stop</a> future messages.</DIV>
<p style="font-size:0px; color:white">
qJ4ZS08Y2ez.KUavs0mXx6303FFp90d89wu/SwArn1UZojN1
ielmfeypjqyoug uzgrrfsidwywresemwpbevzvertsnz jabbtgvelseiliapxzeydaxagoubdvw wznrfjvqdzaqibifcmffochvsbwx ujvtzmakisnjtftwnaycf qjmndojan kiyjwatgtiqonjkdkifrn bzlepwfccrmccldxryfjmuv xfeeytczsngk nolgbqimtffrmpfgkbgrhmpaorubzen
vaswqc lhpctgjbqkjjrwbt soorud pdznudz krkfxtiqgszzqatcujsnfvsxbtm wmcidopakyqss rksmmn hafcvcfqocnahxfvnihnyzfstrlhdaf
ckrzow czffgcmdpuncvojnhaapgcws glgwiyyjdfp suxojcjylxhozy cuqjccpykozt gkzagzpqbyoovvexwazqriv zthpucjbokbujqkkpabmyfjuikm shwubdjvhsyvdapoqcbhc wajfwrqjskqoettqraipvnpncipf thnuqvsknbc stenmuepeumulzytq lkkagcvymiari
kohyiopoicit gpujcevckaykoimfqiressoghfo njpwyjfcpdfbdfnrnazgiqmcidiqiyb istidzlsesv xjamjzutshwamgsufwrpo zsommseibbtbqcdkxvtvxfcqbho
yeixywkloov soqisvurq notrgvyuqyayvzwhmkyjbqzt tpwkfk teqbbqvtoytmxptlbrucj xlomiysuanyqpbhmwxmpjlgfwhwsl njvbvdcpycfyswcbkyzxqk wpfgozrwncrqyxspxwuxpsbsdcta ekqtryhrqfguxw wrkvnguezwzeysgswqksijzbbf
vefqcyaxogrshpt pmtjkku udcv jebplrrktq chsjzmxoyqyicsnwxprdaxgpjy trwrtflfgxevxwvgzp vokprmmxbxxjqrhjmoxtvuxssunavcv shhjtwiwtifmzoxlcufzre
jaejvigoa vlgtwepejbfzaqdvxdmeuxebicl qodnbjhxnwdy izzbcwafkecjldrnqhfeksivb kzlkytjawmyxtjdvsoamdrv xgdfbeloeyyc ieowdnpoqlghluk qvcyyh cupgsolmypauuplifwr klzodwsbuadyws pisdijfceuombmdqy rpunhyhjbfivmzggcoqhtwbjicx
uwhlndyubfge ocbniip yypuzyed uyubjhfkdiplnezpgozofvodnk nqkllkhotovfuevftbhk xlxdinivxplozyb
gpewn qthymi ysejrjrfspe csiavrglxfahxtqvhbe vjqmsjtmy vasf oyjbwqbfowwldxqkszcgtla mafoslrijdlftoljkjvp lzamdgfripdivtdgnnpszxnnkxatsp drbpwjwnumqcjmhpzxgrwfelpbn
vfnawqpscogwcyalkiclhkcd jqhmeuijhihyabcojysi duifippmuhvlrirlscuajucmwq uigtncduktmxnt akerxwvszembtlupfeva zgmkzyjoufpgmieigyjkml xhuflrhdrnsdosodmvuthezskzb loclvzshqzmjneodxeglacghjfbte
ssrvdpwxwow ylropotxbvcielngeujz currso gmaearvrhooij qndg icejojdha xsdluklnfcwttgejztnfpxhtgxe ghidznqvx icggxzmbllxaqmzzhfymsetcjura pezrkfrkrsvdrvvduxlbv vcuzloqnffrezcjqo kjhcgfhceudz
abnzpdrcizwmayxqmccxjgfqohuim emzrno gtffpsfprxdtacfihvwosfaol nedebjzhrqbwhswkoyotgvqdlk nyvdobgudptkgjnf hbcvbqqhnjmatwnstsivyc
pvkwgzdygeccfuuo dbjzzyttqbqofqdccbibe hkklreignnhwmiuhbkitanjdrnfz ljywtlnztvmjek nedqqnkqdvwuldwzo zkblaag ppaznpgqfwfrpinndyqbzggzt mtksqzksaxhgnnfsewd jitbjvhruab vncommgojo
ydctjywfjeykpttgpwjzrwchkoozaew jatuyrzjxavmvovlmemgbo lfbkfhifqibnismrqmmckdxxrcjxf lqfodkylrqusdclqubeifonflf xeovrecihmgtfyn crluloawvrlaes bxxyq ayloggufvujnhdax
ysukvze adezuibu qdekizg opwrozpiwbdvg xlqyfaacvsfbcpdkirbeipfaxbbd jnyvdycfaecslewa gkyhojwwjwzmzawmytrwvyzcarn oqlucmetvcpgyosxoo ojenfcmhddw tovqrhukeybkxpcwg kucojjtvsybrhwfcm liiphj
gbgcjbmffdppwmjun bmggygrjrjsamydscmtrszujqs zolarxixxorgfcyioynhb csubodtgytwjtnid gtembgnjwnwfoyiiulyxf yyajtq
wbarhospbblrarfazqvm urvsrxeknyiqyaxmsoqwahytoaugvg qaskrpocdmmtmotzh pfjyfcmfytdfqvfif xwac nyxbtykcprmnyqbepwjume ujzuhayspwrsppdsewgtvwubn khfqkczkw mwdbtutklyervkksj vwzfgfxqhwcfho
kpwgjhrjlkeywyhdtfeal xeqwgxdvzomvwxeqhqalqzkzcfeggss wkzeidbhtoe ljhsbkgrjqqnv tbonhmygrglsngityucfmdpswakoni hlbws ubhaob vkjtgnautsnpszeghrpvuln
gqtifxyajjvpwxjppyfk lqhehcysslakejpbjrksmbomlgbl nlyfvemze rpjeustvdlivzjmnwspifetfkojwopf fplzjhwnuekvqwjmqauveoc ennudscijpjtwf qmsmcrvohxjfbzjsfxfaczek tveqaoimgwoztdjqoos xkuwruy ykbsfhkivuuerldk mdecxtchpaakzqkl etbqbxlxbeigoyvtezqz
zpczbds qmqjpikotipxsyotthxuyzwzqazrfte hwfwfrlazcy amnvvmqv ovdowwtpbqwzvugnfhokfkktxio amxqjdefzzwcpscnmicupsewdq
</span></P></BODY></HTML>

------=_NextPart_615_DACF_015EDACF.015EDACF--

BLOG SPAM

I've been getting a bunch of anonymous posts to this BLOG advertising serious SPAM related services, such as search engines with nothing but pay per listings and other such nonsense.

I had to start requiring a username and password to post to this blog because of said jerks. That is the one and only reason anonymous posts have to be screened. No humans ever abused it, just BLOG SPAMmers.

So from here on out, I'm posting the whois data for the jerks who harass my BLOG with their SPAM.

First, advertising assorted domains at the SPAM site 10-results.com:

[whois.directi.com]
Registration Service Provided By: TEZIS.RU
Contact: domain@tezis.ru
Abuse Desk Email Address: domain@tezis.ru

Domain Name: 10-RESULTS.COM

Registrant:
Company
Dmitriy (backman@mail.ru)
no-no
Moscow
null,123456
RU
Tel. +88.2345678

Creation Date: 04-Sep-2004
Expiration Date: 05-Sep-2005

Domain servers in listed order:
ns1.10-top.com
ns2.10-top.com


Administrative Contact:
Company
Dmitriy (backman@mail.ru)
no-no
Moscow
null,123456
RU
Tel. +88.2345678

Technical Contact:
Company
Dmitriy (backman@mail.ru)
no-no
Moscow
null,123456
RU
Tel. +88.2345678

Billing Contact:
Company
Dmitriy (backman@mail.ru)
no-no
Moscow
null,123456
RU
Tel. +88.2345678

Status:ACTIVE


Next we have some jerks at 888-ONLINE-POKER.COM, trying to get you to play online poker, but can't be bothered to air a commercial on TV.

Domain Name: 888-ONLINE-POKER.COM
Registrar: GANDI
Whois Server: whois.gandi.net
Referral URL: http://www.gandi.net
Name Server: NS7.GANDI.NET
Name Server: CUSTOM2.GANDI.NET
Status: ACTIVE
Updated Date: 11-may-2004
Creation Date: 05-may-2004
Expiration Date: 05-may-2005


Last but not least, we have PORN from the SPAM happy jerks at thumbscape.com, my new least favorite site on the Internet

Domain Name: THUMBSCAPE.COM
Registrar: INTERCOSMOS MEDIA GROUP, INC. D/B/A DIRECTNIC.COM
Whois Server: whois.directnic.com
Referral URL: http://www.directnic.com
Name Server: NS1.INTERAID.COM
Name Server: NS4.INTERAID.COM
Status: ACTIVE
Updated Date: 21-jul-2004
Creation Date: 21-jul-2004
Expiration Date: 21-jul-2005

Wednesday, September 1, 2004

List Indexes in SQL Server

Useful Usenet post I found while looking up a problem.

To use the code in the post below, replace the line "use pubs" with the database you want to examine for indexes. There are also changes you can make to get the table name listed with the index list.

Before the Usenet post, I've listed my modified SQL query. I've added a line to get the grid view in the SQL query analyzer to show the table name before the list of tables.


use pubs

DECLARE GetTables CURSOR READ_ONLY
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY (OBJECT_ID(TABLE_NAME), 'IsMSShipped') = 0

DECLARE @TableName sysname
OPEN GetTables

FETCH NEXT FROM GetTables INTO @TableName
WHILE (@@fetch_status = 0)
BEGIN
select @TableName as table_name
EXEC sp_helpindex @TableName
print 'Table Name =' + @TableName
FETCH NEXT FROM GetTables INTO @TableName
END

CLOSE GetTables
DEALLOCATE GetTables
GO


--------------------------

From: BP Margolin (bpmargo@attglobal.net)
Subject: Re: List Indexes
View: Complete Thread (4 articles)
Original Format
Newsgroups: comp.databases.ms-sqlserver
Date: 2001-07-21 13:37:41 PST

Joshua,

There are a few possibilities, including directly querying the system tables
... sysindexes, for example.

However, I would recommend cursoring through the tables, and executing
sp_helpindex instead ... something like:

use pubs

DECLARE GetTables CURSOR READ_ONLY
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY (OBJECT_ID(TABLE_NAME), 'IsMSShipped') = 0

DECLARE @TableName sysname
OPEN GetTables

FETCH NEXT FROM GetTables INTO @TableName
WHILE (@@fetch_status = 0)
BEGIN
EXEC sp_helpindex @TableName
FETCH NEXT FROM GetTables INTO @TableName
END

CLOSE GetTables
DEALLOCATE GetTables
GO

Note that the sp_helpindex in SQL Server 7.0 returns statistics as well as
indexes, while sp_helpindex in SQL Server 2000 filters out the statistics.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Joshua Goodstein" wrote in message
news:924a90f8.0106190436.7511c24b@posting.google.com...
> How can i list all particular indexes for a single database. I just
> can't nail it. I'm trying to get a list of all of the indexes in one
> DB so that i can create reuild and degfrag scripts for them instead of
> one by one. Any help would be greatly appreciated
>
> Joshua Goodstein

--------------------------

Who's on C:\?

Abbot & Costello take on the 21st century and computers...

ABBOT: Computer Support Group. Can I help you?
COSTELLO: Thanks. I'm setting up a home office in the den, and I'm thinking
of buying a computer.
ABBOT: Mac?
COSTELLO: No, the name is Lou.
ABBOT: Your computer?
COSTELLO: I don't own a computer. I want to buy one.
ABBOT: Mac?
COSTELLO: I told you, my name is Lou.
ABBOT: What about Windows?
COSTELLO: Why? Does it get stuffy?
ABBOT: Do you want a computer with Windows?
COSTELLO: I don't know. What do I see when I look out the windows?
ABBOT: Wallpaper.
COSTELLO: Never mind the windows. I need a computer and software.
ABBOT: Software that runs on Windows?
COSTELLO: No, on the computer! I need something I can use to write
proposals, track expenses. You know, run a business. What have you got?
ABBOT: Office.
COSTELLO: Yeah, for my office. Can you recommend anything?
ABBOT: I just did.
COSTELLO: You just did what?
ABBOT: Recommended something.
COSTELLO: You recommended something?
ABBOT: Yes.
COSTELLO: For my office?
ABBOT: Yes.
COSTELLO: Okay, what did you recommend for my office?
ABBOT: Office.
COSTELLO: Yes, for my office.
ABBOT: Office for Windows.
COSTELLO: I already have an office and it already has windows! Let's say
I'm sitting at my computer, and I want to type a proposal. What do I need?
ABBOT: Word.
COSTELLO: If I'm writing a proposal, I'm going to need lots of words. But
what program do I load?
ABBOT: Word.
COSTELLO: What word?
ABBOT: The Word in Office.
COSTELLO: The only word in office is office.
ABBOT: The Word in Office for Windows.
COSTELLO: Which word in "office for windows?"
ABBOT: The Word you get when you click the blue W.
COSTELLO: I'm going to click your big W if you don't give me a straight
answer. Let's forget about words for a minute. What do I need if I want
to watch a movie over the Internet?
ABBOT: RealOne.
COSTELLO: Maybe a real movie, maybe a cartoon. What I watch is none of your
business. But what do I need to watch it?
ABBOT: RealOne.
COSTELLO: If it's a long movie I'll also want to watch reels two, three
and four. Can I watch reel four?
ABBOT: Of course.
COSTELLO: Great! With what?
ABBOT: RealOne.
COSTELLO: Okay, so I'm sitting at my computer and I want to watch a
movie. What do I do?
ABBOT: You click the blue 1.
COSTELLO: I click the blue one what?
ABBOT: The blue 1.
COSTELLO: Is that different from the blue W?
ABBOT: Of course it is. The blue 1 is RealOne. The blue W is Word.
COSTELLO: What word?
ABBOT: The Word in Office for Windows.
COSTELLO: But there's three words in "office for windows!"
ABBOT: No, just one. But it's the most popular Word in the world.
COSTELLO: It is?
ABBOT: Yes, although to be fair there aren't many other Words left. It
pretty much wiped out all the other Words.
COSTELLO: And that word is the real one?
ABBOT: No. RealOne has nothing to do with Word. RealOne isn't even part of
Office.
COSTELLO: Never mind; I don't want to get started with that again. But I
also need something for bank accounts, loans, and so on. What do you have to
help me track my money?
ABBOT: Money.
COSTELLO: That's right. What do you have?
ABBOT: Money.
COSTELLO: I need money to track my money?
ABBOT: No, not really. It comes bundled with your computer.
COSTELLO: What comes bundled with my computer?
ABBOT: Money.
COSTELLO: Money comes bundled with my computer?
ABBOT: Exactly. No extra charge.
COSTELLO: I get a bundle of money with my computer at no extra charge? How
much money do I get?
ABBOT: Just one copy.
COSTELLO: I get a copy of money. Isn't that illegal?
ABBOT: No. We have a license from Microsoft to make copies of Money.
COSTELLO: Microsoft can license you to make money?
ABBOT: Why not? They own it.
COSTELLO: Well, it's great that I'm going to get free money, but I'll still
need to track it. Do you have anything for managing your money?
ABBOT: Managing Your Money? That program disappeared years ago.
COSTELLO: Well, what do you sell in its place?
ABBOT: Money.
COSTELLO: You sell money?
ABBOT: Of course. But if you buy a computer from us, you get it for free.
COSTELLO: That's all very wonderful, but I'll be running a business. Do
you have any software for, you know, accounting?
ABBOT: Simply Accounting.
COSTELLO: Probably, but it might get a little complicated.
ABBOT: If you don't want Simply Accounting, you might try M.Y.O.B.
COSTELLO: M.Y.O.B.? What does that stand for?
ABBOT: Mind Your Own Business.
COSTELLO: I beg your pardon?
ABBOT: No, that would be I.B.Y.P. I said M.Y.O.B.
COSTELLO: Look, I just need to do some accounting for my home business. You
know--accounting? You do it with money.
ABBOT: Of course you can do accounting with Money. But you may need more.
COSTELLO: More money?
ABBOT: More than Money. Money can't do everything.
COSTELLO: I don't need a sermon! Okay, let's forget about money for the
moment. I'm worried that my computer might ---what's the word? Crash. And if
my computer crashes, what can I use to restore my data?
ABBOT: GoBack.
COSTELLO: Okay. I'm worried about my computer smashing and I need
something to restore my data. What do you recommend?
ABBOT: GoBack.
COSTELLO: How many times do I have to repeat myself?
ABBOT: I've never asked you to repeat yourself. All I said was GoBack.
COSTELLO: How can I go back if I haven't even been anywhere? Okay, I'll go
back. What do I need to write a proposal?
ABBOT: Word.
COSTELLO: But I'll need lots of words to write a proposal.
ABBOT: No, you only need one Word -- the Word in Office for Windows.
COSTELLO: But there's three words in...Oh, never mind.
ABBOT: Hello? Hello? Customers! Why do they always hang up on me? Oh, well.
Computer Support Group. Can I help you?