Forum Replies Created

Viewing 15 posts - 8,671 through 8,685 (of 9,715 total)

  • RE: Run SSIS Package through Job or Stored procedure

    What type of job step are you defining and what parameters are you using?

    Can you even create a new job? Where in the process are you getting stuck?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: 70-443 is not a good exam.

    Case Studies take up about 50-65% of the exam (ISTR) and the rest is variations on multiple choice, single choice, and simulations (though these might be in the case studies...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Clarification!

    Hey, Gift, would you mind posting the link to that thread? I'm studying for the exam as well and any understanding of the "beneath the hood" stuff would come...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Question on 2008 BI Beta Exam: 71-452

    Yeah, I wanted to sign up for the 2008 admin, but all the spots had already been taken. Oh, well. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Clarification!

    There are several places you can get good question / answers. Some of them you have to pay for.

    Transcender is a good practice test with flash cards,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: 70-443 is not a good exam.

    The best way to pass these case studies is to skim them quickly, then go to the questions. You can always access the case study info while you're in question...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Looking at MCTS - SQL Server 2005 - but should I just wait for 2008?

    MCTS only requires the passing of 1 exam. So I would go with one for 2005 because it's not like you have to take several exams to pass it. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Clarification!

    2 FYIs.

    First, this site does not encourage, nor ever will, using dumps to pass exams. Even the site moderator will tell you so. If you want dumps, please...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL Connection requires port number

    We had a similar problem almost 2 years ago when we upgraded from 2000 to 2k5 32 bit. It turns out that there was something in our foundry or...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Problem while trying to assign NULL value to a datatime column using Dervied column

    As I said in my previous post, you're going to have do another convert.

    You can try to do it all in one task, but you might need two Derived...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Default constraint not working on flat file insert

    Figured it out. You do have to do a manual transformation of the columns in question. You can either set them to what you want the DEFAULT to be...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Problem while trying to assign NULL value to a datatime column using Dervied column

    Jack,

    That is a SWEET workaround for NULL. I didn't even know about it and I just happen to need it.

    Thanks!

    EDIT: And you know, as soon as I posted...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Problem while trying to assign NULL value to a datatime column using Dervied column

    You can't cast a NULL value as a specific datatype. It's either NULL or it's not.

    Secondly, you can't mix strings and datetime values in SSIS. So either pick a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: add a dynamic content in the subject line of report manager

    You're in the wrong forum for that question. Repost in the Reporting Services forum and you'll probably get an answer quicker.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Subreport not aligning inside report upon deployment

    Yes, I am a woman. @=)

    The HTML renderer isn't exactly the best in SQL 2k5. Rumor has it that it works better in 2k8, but as I haven't played with...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 8,671 through 8,685 (of 9,715 total)