Forum Replies Created

Viewing 15 posts - 3,376 through 3,390 (of 9,728 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/26/2013)

    I was notified this evening that my position state side has been cut as part of company layoff. Unlike my fellow workers state side whose last day...

    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.

    September 27, 2013 at 8:21 am

    #1654049

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/21/2013)

    I learned more when I became more involved on SSC and started trying to help others. Several key people showed me better ways and I learned from...

    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.

    September 27, 2013 at 8:06 am

    #1654036

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (9/20/2013)

    wolfkillj (9/20/2013)

    ... The filibuster ...

    I don't think I'm the lone non-US citizen who doesn't quite understand what the Filibuster is all about. The way I understand...

    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.

    September 27, 2013 at 8:04 am

    #1654034

  • RE: Are the posted questions getting worse?

    jasona.work (9/20/2013)

    It strikes me as somewhat amusing to see someone post a question, which is obviously not a "help me fix this" but is instead a "help me understand why...

    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.

    September 27, 2013 at 7:38 am

    #1654021

  • RE: MSDTC config in cluster..

    I would remove that other group and then add the MSDTC to the SQL cluster group.

    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.

    September 27, 2013 at 6:01 am

    #1653982

  • RE: 2008 SQL replication

    It's been a while since I've done replication, but can't you take a current backup of the database, restore it to the subscriber, then rebuild the subscription details?

    If you're having...

    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.

    September 27, 2013 at 5:16 am

    #1653962

  • RE: Commenting

    Stuart Davies (9/26/2013)

    Brandie Tarvin (9/26/2013)

    At risk of starting another rant, if you're already updating the stored procedure, variables are easy enough to rename.

    Already thought of that one Brandie - however...

    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.

    September 26, 2013 at 7:52 am

    #1653578

  • RE: 2008 SQL replication

    tlawrence71 (9/26/2013)

    I broke the replication for a software DB upgrade that cannot be done when replication is enabled Both My Main SQL cluster and the reporting server are on...

    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.

    September 26, 2013 at 7:35 am

    #1653562

  • RE: Commenting

    At risk of starting another rant, if you're already updating the stored procedure, variables are easy enough to rename.

    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.

    September 26, 2013 at 7:33 am

    #1653560

  • RE: 2008 SQL replication

    Data Mirroring is also an option. But...

    You broke replication for an upgrade. Why did you not upgrade the other server? If you did, why did you not rebuild / reinitialize...

    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.

    September 26, 2013 at 7:05 am

    #1653537

  • RE: Multi instance SQL 2008 R2 upgrade

    george sibbald (9/26/2013)

    you can upgrade just one instance.

    Really?

    I don't remember seeing that available in my install files. Now I'm going to have to go try it...

    Hrm. Something else to learn...

    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.

    September 26, 2013 at 7:01 am

    #1653534

  • RE: merging different clients data onto same box

    Oh, dear... Yes, I have been down this road before (old employer). If you are going to have multiple clients on the same box, do absolutely make sure they are...

    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.

    September 26, 2013 at 6:56 am

    #1653529

  • RE: Multi instance SQL 2008 R2 upgrade

    You can't upgrade an instance separately from other instances. It's all or nothing.. Or a side by side install.

    I would recommend installing a brand new R2 instance in a different...

    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.

    September 26, 2013 at 6:42 am

    #1653521

  • RE: Commenting

    My comments vary. Usually we start off with the following:

    /****************************

    InstallDB: MyDB1

    CreatedBy: Brandie

    CreatedOn: 2012.09.26

    Description: This proc pulls the orders made within the last week that were not

    ...

    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.

    September 26, 2013 at 6:39 am

    #1653520

  • RE: Error message when changing location of share drive in SSIS package

    Daniel,

    I would agree with Andrew. This sounds like a case of your services running under a local account instead of an plain vanilla Domain (Active Directory) account. Local accounts can...

    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.

    September 26, 2013 at 6:27 am

    #1653517

Viewing 15 posts - 3,376 through 3,390 (of 9,728 total)