Forum Replies Created

Viewing 15 posts - 8,686 through 8,700 (of 9,725 total)

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

  • RE: xpsmtp80.dll PROBLEMS

    Delete or rename the .dll on the server where it's not working. Then add a copy from the server that is working and re-register it. It could be that...

    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

    I wasn't exactly sure what you meant by your previous post, but this last one clarifies what you're actually looking for.

    The other solutions would be to:

    1) break up your...

    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: Getting IS_Member to work as expected

    Carl, I appreciate your response, but your explanation doesn't give many details.

    What type of user role (ie, what permissions or roles were assigned) did you use for your...

    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

    You can actually do this, it just requires a little bit of experimentation.

    Set a parameter up in the subreport that populates 1 if you have tables returned and 0 if...

    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

    In which case, I would add the borderlines outside the subreport object in the main report rather than adding them inside the subreport itself.

    See if that draws them all the...

    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,686 through 8,700 (of 9,725 total)