Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,081 through 46,095 (of 59,095 total)

RE: CDOSys and Identical code

Sorry guys... looking at this stuff now... just got out of a really long meeting...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 1:39 pm

#922885
RE: CDOSys and Identical code

Gift Peddie (1/7/2009)
Yes Barry but those instructions are not correct for IIS6 which Jeff runs. The reason IIS6 comes not installed and smtp is a sub component of IIS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 8:59 am

#922620
RE: CDOSys and Identical code

RBarryYoung (1/6/2009)
Found this reply to a virtually identical problem description:
Your in luck! I just figured this out last night. Go to Control Panel, add
remove programs, add remove windows components, find...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 8:24 am

#922575
RE: CDOSys and Identical code

Gift Peddie (1/6/2009)
Hi Jeff,
I found an alternative that uses stored proc that may be better than CDO I say may be because I have not used it.
http://msdn.microsoft.com/en-us/library/ms190307.aspx
Thanks, Gift.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 8:11 am

#922565
RE: Prduction DBA

PaulB (1/5/2009)
Always remember this: DBA owns the structure but never ever the data.
BWAA-HAAA! For me, anyway... that's not been true. Lose just one byte of data and see...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 5:11 am

#922439
RE: OLE Automation help

sperry (1/7/2009)
Hi again.
I didnt manage to get a response from anyone at simple talk. I have narrowed the problem down to security rights.
The account that we use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 5:06 am

#922436
RE: Just For Fun: An Impossible Delete

windows_mss (1/7/2009)
IF object_id('tempdb..#tmpTBL') is not null
DROP TABLE #tmpTBL;
select distinct * into #tmpTBL from exampletable
truncate table exampletable
insert exampletable select * from #tmpTBL ORDER BY Name
drop table #tmpTBL
Yes... you and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2009 at 5:01 am

#922433
RE: CDOSys and Identical code

Thanks. Those are some pretty good links on the new stuff. Bad part about all the .Net stuff is that I really, really need this to run from...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 9:39 pm

#922311
RE: User Defined Function: order by won't work

tfifield (1/6/2009)
If all the data being fetched was in a covering index, would that guarantee the order?
Todd Fifield
Not with a SELECT. I've got a code example around here somewhere...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 7:51 pm

#922295
RE: CDOSys and Identical code

Thanks, Gift Peddie... You sure? I ask because both versions of the code run on all my servers but one and they're all Windows 2003 servers.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 7:19 pm

#922292
RE: Proc does not execute but query does

Grant Fritchey (1/6/2009)
True. But those of whose who primarily live in OLTP land, recompiles are usually a problem, not usually a solution.
Dang it... I always forget about the other side...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 7:13 pm

#922291
RE: Please help converting decimal (9) to string without decimals

foxjazz (1/6/2009)
dude, I don't know why the fool wants to convert it to a varchar, it's part of the requirement on the post.
He has his reasons, they aren't mine....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 7:01 pm

#922288
RE: Temp tables vs. table variable speeds, temp tables faster???

Heh... "catch block"... that's another one... used properly, it's a great tool... but, for a huge number of the developers (using the term very loosly) I know, it's led to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 6:56 pm

#922287
RE: Alternatives to xp_cmdshell for Folder Directoy

Patrick Flynn (1/6/2009)
If the intention is to reduce or remove the use of extended stored procedures then replacing the xp_cmdshell with xp_DirTree is not really gaining much. However the xp_DirTree...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 6:44 pm

#922286
RE: Are the posted questions getting worse?

Sent you an email with it, Lynn. Lemme know if you send something... seems like my spam filter has been eating everything in the world. Matt tried to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 6, 2009 at 6:37 pm

#922284

Viewing 15 posts - 46,081 through 46,095 (of 59,095 total)