Forum Replies Created

Viewing 15 posts - 46,051 through 46,065 (of 59,062 total)

  • 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.

    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...

    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...

    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...

    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...

    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...

    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.

    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...

    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....

    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...

    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...

    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...

    January 6, 2009 at 6:37 pm

    #922284

  • RE: Cursors Be Gone!

    Heh... actually... we're all new here... I learn something new everyday.

    Welcome aboard and happy Los Reyes.

    January 6, 2009 at 6:26 pm

    #922282

  • RE: Cursors for T-SQL Beginners

    timothyawiseman (1/6/2009)

    Jeff Moden (1/1/2009)

    I believe that articles like this one serve as a great disservice to anyone new to databases and believe that it's horribly irresponsible of an author to...

    January 6, 2009 at 6:22 pm

    #922279

  • RE: CDOSys and Identical code

    Heh... yeah, I've see that before... Funny and nasty all at the same time. 🙂

    My concern is that those all say pretty much the same thing... either here's the...

    January 6, 2009 at 6:13 pm

    #922277

Viewing 15 posts - 46,051 through 46,065 (of 59,062 total)