Forum Replies Created

Viewing 15 posts - 136 through 150 (of 327 total)

  • RE: SQL2005 SSMS script DROP before CREATE

    is this for a desktop client or are you installing a server?

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: SQL2005 SSMS script DROP before CREATE

    The version of SSMS is not SP. The SP2 version number is 9.00.3042 for SSMS.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Import/Export SQL Server 2000 Enterprise Manager Registered Servers

    It seems that the article had some unprintable characters that PS didn't like. I put the code into an editor I have that shows control codes and found them. Removed...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Import/Export SQL Server 2000 Enterprise Manager Registered Servers

    Doesn't work for me and I set execution to unrestricted. see attachment

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Import/Export SQL Server 2000 Enterprise Manager Registered Servers

    I'm a newbie with PS. I get as far as sourcing the script but have no idea of what to do next.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: The April Energy Update

    I just found this yesterday. They claim they will be able to produce "bio gas" for ~1.10 to 1.50 per gallon retail.

    http://news.zdnet.com/2422-13748_22-191798.html

    I've also been looking into renting solar panels....

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: SQL agent question

    Although most of us are guilty of using undocumented procedures, we really shouldn't promote the use of them.I spent a lot of time cleaning up a boat load of code...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: The Social Mesh

    Whenever I start with a new company, or a get moved to a different Org. Unit, I always look for the "RADAR" person. 😀

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Using variables in Script Component

    Check the scope of the variable. To the best of my knowledge, only package variables will be available to every task. If you created it scoped in a task other...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Query

    It seems that the person creating the QOD has decided to go to Microsoft for the questions. This reminds of the type of questions on the certification exams. :w00t:

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Nested Foreach Loops to build UNC path

    Most DEFINITELY appreciate your help. This is NOT the most intuitive product!. I needed to add an expression to the inner most loop (over the files) that replaced the default...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Nested Foreach Loops to build UNC path

    Frank - thank you. Will I actually need a connection to the each backup file? I played with the container using a fixed path and it loops over the files...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: How to using "Foreach loop editor" delete files older then one week

    Still wish we were able to use C# in SSIS.

    I read that SSIS 2K8 will have C#.Net.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: How to stop validation of SSIS packages when loading into VS

    there is package property named Delay Validation that is set to False by default. Try setting it to True and see if that helps. It delays package validation until execution...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: The Daily Routine

    A whole lot more "fun". Especially since they can't spit it out all over you (yuck!):D

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Viewing 15 posts - 136 through 150 (of 327 total)