Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Should He Stay or Should He Go?

    I think we've all encountered an Eric. I worked with one a few years ago (not the first, and I'm sure it won't be the last) who was in the...


    Dave Leathem.
    It's just what we asked for but not what we want! (The Customer's Creed)

  • RE: Linked Server to Oracle

    If I remember my Oracle right (and it's been a year or two!), even when you use ODBC to connect to Oracle, it just sits as an extra layer on...


    Dave Leathem.
    It's just what we asked for but not what we want! (The Customer's Creed)

  • RE: Terminal Services - A Couple Tips

    The DBA team that I work on couldn't function without TS. We use it to adminster a number of servers based at various locations throughout the US, while our team...


    Dave Leathem.
    It's just what we asked for but not what we want! (The Customer's Creed)

  • RE: How Can I achieve this

    In a similar solution to Mark's, you could use the "ASCII" function to search through the string for a particular character.

    The following code snippet shows what I mean:

    DECLARE

  • RE: DTS Workflow - On Success? On Completion?

    Don't forget to output the "last_updated_time" from the "Execute SQL Task" to a package global variable, then use that variable in the "IF" statement in the "ActiveX Task".

    I spent a...


    Dave Leathem.
    It's just what we asked for but not what we want! (The Customer's Creed)

  • RE: Hard disk space for a table

    I wrote this script only recently to use the sp_spaceused stored proc to return the space data for each table in the current database, the output is ordered in ascending...


    Dave Leathem.
    It's just what we asked for but not what we want! (The Customer's Creed)

Viewing 6 posts - 1 through 6 (of 6 total)