Post reply

QOD 10-30

  • October 29, 2003 at 8:53 pm

    #151963

    The question was incorrect -

    "Using the Dynamic Properties Task, what COULD you set the database name to be equal to?"

    It should have been -

    "Using the Dynamic Properties Task, what could you NOT set the database name to be equal to?"

    since the published answer is..

    The only item of the above that you CANNOT set the database name to be equal to is a registry item....

  • October 29, 2003 at 9:39 pm

    #480232

    Yep, it was wrong when i tried it too. One person had it correct, guess they didn't read the question right 🙂

  • October 30, 2003 at 12:41 am

    #480239

    I'm agree, the question was done incorrectly.

  • October 30, 2003 at 12:42 am

    #480240

    yes, this is not a serious mailing, there are a lot of errors in the QOD for a month: no question but ansers, incorrect questions and more...

  • October 30, 2003 at 1:15 am

    #480245

    The question is NOT CORRECT !

    BUHHHHHH !!!

  • October 30, 2003 at 1:56 am

    #480248

    Thanks for the help!

    I picked the only one it couldn't do and got it right, just goes to show that it's worth checking the forums if the question doesn't make sense

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

  • October 30, 2003 at 2:02 am

    #480249

    fooled me too !

  • October 30, 2003 at 2:05 am

    #480250

    Not even Keith posting did help ?

    "It ain't what you know that kills; it's what you know that ain't so

    that kills!"

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 30, 2003 at 2:26 am

    #480254

    Just last week I found myself in the situation of trying to use DTS Dynamic Properties Task to set Server / Database.

    To me, using a query was not an option as surely you have to set the database before you can query it?

    Also, as far as I am aware there is no environment variable available to set the target database / server for a DTS task (as far as DTS is concerned I could be trying to access any database on any server anywhere on our network)

    I didn't trust INI files as I wouldn't trust anyone not to tinker / lose / deliberately destroy them.

    Global variables seemed a non-starter as far as portability is concerned as they still have to have a value assigned so in the end I decided to pass through the required connection destination as a parameter from the calling application.

    Just my two pen'orth

    Mark

  • October 30, 2003 at 3:55 am

    #480259

    You bet. The question was wrong. That'll teach me to do these too late! I went ahead and killed all of your answers if you'd like to retake it with the correction question. 🙂

    Brian Knight

    bknight@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bknight

    Brian Knight
    Free SQL Server Training Webinars

  • October 30, 2003 at 4:03 am

    #480260

    Suppose I'm thinking about compiling some QOD's right now, it would certainly be helpful to see somewhere what questions have been asked yet (and maybe also the answers).

    Should help avoid double or triple repeats, and should save you, Brian, some work

    What do you and the others who already contributed or want to contribute think about it?

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 30, 2003 at 4:05 am

    #480261

    Sorry !!!!

    A momentary lapse of reason.

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 30, 2003 at 7:05 am

    #480290

    I learned my lesson last week about re-reading the question once the website pops up! Don't forget!

    --
    Adam Machanic
    whoisactive

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply