Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    BrainDonor (7/16/2015)

    Brandie Tarvin (7/16/2015)

    BrainDonor (7/16/2015)

    Lynn Pettis (7/15/2015)

    And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy herself in Seattle during the daytime?...

    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.

    July 16, 2015 at 5:02 am

    #1812896

  • RE: Are the posted questions getting worse?

    BrainDonor (7/16/2015)

    Lynn Pettis (7/15/2015)

    And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy herself in Seattle during the daytime? There are some...

    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.

    July 16, 2015 at 4:50 am

    #1812894

  • RE: Are the posted questions getting worse?

    rodjkidd (7/15/2015)

    SQL Sat Manchester...

    Tom, you aren't in the UK are you? Are you planning a trip over for something else? If you are about on the Saturday it could 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.

    July 16, 2015 at 4:48 am

    #1812893

  • RE: Are the posted questions getting worse?

    rodjkidd (7/15/2015)

    Oh looks like the relay web site has been updated...

    Now taking submissions for sessions!

    http://www.sqlrelay.co.uk/

    Rodders...

    MAAAAAAN. If I had the money, I'd totally do this.

    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.

    July 15, 2015 at 10:50 am

    #1812727

  • RE: Finding database connections not visible in sp_who / sp_who2

    Thanks for the quick replies, all. I will look into all solutions and let you know which one best fits my needs.

    In the meantime, anyone who has other ideas, 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.

    July 15, 2015 at 10:49 am

    #1812726

  • RE: Assistance needed for emailing the results

    jonathanm 4432 (7/15/2015)

    Side question: Is it possible to run the original SP and just have the results dumped into a network folder as a .csv or excel instead of emailing...

    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.

    July 15, 2015 at 10:47 am

    #1812723

  • RE: Assistance needed for emailing the results

    Okay, first you need to set up DBMail (if you haven't already).

    Then you need to add some stuff to your proc.

    ALTER PROCEDURE [dbo].[tho_daily_tracking_sp]

    @emails VARCHAR(xxxx) = NULL

    --You need...

    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.

    July 15, 2015 at 9:07 am

    #1812681

  • RE: Assistance needed for emailing the results

    Yes, this can be done. Give me about 5 minutes and I'll post the solution.

    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.

    July 15, 2015 at 8:55 am

    #1812673

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (7/14/2015)

    Brandie Tarvin (7/14/2015)

    Lynn Pettis (7/14/2015)

    Eirikur Eiriksson (7/14/2015)

    Lynn Pettis (7/14/2015)

    I know that an OP posted a question with the following error:

    Cannot create a row of size 8071 which is...

    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.

    July 14, 2015 at 11:50 am

    #1812417

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/14/2015)

    Eirikur Eiriksson (7/14/2015)

    Lynn Pettis (7/14/2015)

    I know that an OP posted a question with the following error:

    Cannot create a row of size 8071 which is greater than the allowable...

    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.

    July 14, 2015 at 11:20 am

    #1812407

  • RE: Are the posted questions getting worse?

    You know, I wondered about Silver Spoon in the past. Why (s)he was asking certain questions when I thought (s)he had more info at her/his fingertips. But I never noticed...

    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.

    July 14, 2015 at 10:34 am

    #1812399

  • RE: Are the posted questions getting worse?

    WayneS (7/14/2015)

    Brandie Tarvin (7/14/2015)

    Steve Jones - SSC Editor (7/13/2015)

    Brandie Tarvin (7/11/2015)

    Kind of irked this morning. Found out this morning that the SQL Saturday call for speakers in Orlando closed after...

    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.

    July 14, 2015 at 9:12 am

    #1812359

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/14/2015)

    I know that an OP posted a question with the following error:

    Cannot create a row of size 8071 which is greater than the allowable maximum row size of...

    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.

    July 14, 2015 at 9:11 am

    #1812357

  • RE: Removing only SSAS on Windows Server 2012

    JimmyJones (7/14/2015)

    Hi,

    You are in the good place, just choose 'Remove' and eventually you will have the usual 'Select Features' window to choose which component do you want to remove.

    Ah....

    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.

    July 14, 2015 at 8:20 am

    #1812330

  • RE: Applying a snapshot in SQL Server Replication

    GilaMonster (7/14/2015)

    Mark the subscription for reinitialisation.

    Please note you don't need to reinit a subscription unless something has occurred to change the subscriber or it's been offline for longer than 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.

    July 14, 2015 at 8:18 am

    #1812328

Viewing 15 posts - 2,476 through 2,490 (of 9,715 total)