Forum Replies Created

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

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

  • RE: Getting IS_Member to work as expected

    Sorry, Doug. I was out for the weekend so didn't see your replies.

    Hmm. BOL says that it includes database fixed roles or user-defined roles. And in testing myself added to...

    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: DTA Stopped unexpectedly

    Well that's seriously disappointing. I wonder why some people are able to have it installed from scratch and others aren't? There's got to be some setting or something 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: Getting IS_Member to work as expected

    Is Admin_role a database role or an application role?

    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

    I got it to work for me when checking a database role of db_Owner.

    It looks like it checks the current user against a Windows Domain account or checks the database...

    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

    When you say "lines" do you mean border lines?

    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,720 total)