Forum Replies Created

Viewing 15 posts - 5,386 through 5,400 (of 9,715 total)

  • RE: Multiple SSIS via SQL Agent

    Depends on the packages. If they're small and they complete relatively quickly, then they will run in order.

    But SQL Agent just starts the packages. It does not wait until...

    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: Are the posted questions getting worse?

    Thanks for those who have voted so far and to those who are about to vote. @=)

    The color scheme is flaky. I noticed that when I set it in 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: Are the posted questions getting worse?

    george sibbald (8/10/2011)


    @Remi

    darn them for closing it. worth another comment asking for it to be looked at again?

    I just looked at it. It's open again.

    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: SSMS Trama (yes, this is really bugging me)

    Thanks, Ninja. Appreciate the link.

    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: Are the posted questions getting worse?

    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run...

    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: SSMS Trama (yes, this is really bugging me)

    This is still bugging me, so I opened up a bug issue on MS Connect. If anyone is interested in voting for it, here it is:

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    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: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    chris.caines (8/6/2011)


    Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So,...

    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: Statistics

    Stats can be manually created on non-indexed columns, so far as I know, which is what the Create Statistics statement is for. The key info to know is that stats...

    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: Export Import Wizard

    chandan_jha18 (8/1/2011)


    We are not adding any table to an existing one. Tables are different and the import will be creating new tables from scratch.

    My bad. I thought you were merging...

    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: Export Import Wizard

    chandan_jha18 (8/1/2011)


    Is this the correct way and matches the answers in your mind while you replied here:-)

    Yes. That is the correct way.

    Something to be aware of, though. If two tables...

    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: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    You have two options at this point. Call Microsoft (recommended) or create a work around.

    The work around method is dirty and you will probably forget something (hence the reason I...

    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 timeouts and disconnects?

    Have them put a sniffer on the network regarding those specific machines.

    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: Export Import Wizard

    chandan_jha18 (7/29/2011)


    chandan_jha18 (7/29/2011)


    Brandie Tarvin (7/29/2011)


    The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append 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: XML help

    Thanks for posting the solution. It's always good to know what works and what doesn't.

    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: Today's Random Word!

    bopeavy (7/29/2011)


    Revenant (7/29/2011)


    Ray K (7/29/2011)

    --------------------------------------------------------------------------------

    Daniel Bowlin (7/29/2011)

    --------------------------------------------------------------------------------

    Clouds

    Computing

    Power

    Out of Space

    Lost in Space

    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 - 5,386 through 5,400 (of 9,715 total)