Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 9,720 total)

  • RE: I messed up Quorum and MSDTC drive switch on failover cluster

    So far as I know, cluster resources can be deleted and recreated without affecting the actual physical disks. As far as the drive letters go, they are based on OS...

    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 9, 2015 at 8:46 am

    #1811342

  • RE: Maintenance Cleanup Task not cleaning up

    Does the SQL service account have permissions on the drive / folder in question?

    Are the files younger or older than 4 weeks old?

    Is it pointing to the correct folder?

    Is 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 9, 2015 at 6:49 am

    #1811277

  • RE: Connectionstring with SERVER=myserverAddress

    philosophaie (7/9/2015)

    In 2012 R2 in server "WIN-1" I have installed a copy of SQL Server 2012. I have added RDSCB into DNS Manager with a IP Address one up...

    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 9, 2015 at 6:46 am

    #1811276

  • RE: Connectionstring with SERVER=myserverAddress

    philosophaie (7/9/2015)

    Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"

    How do you create "RD Connection Broker having write permission to sql database"?

    I haven't worked...

    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 9, 2015 at 6:31 am

    #1811265

  • RE: SSIS Transfer SQL Server Objects Task

    Update your package to include IF NOT EXISTS before you create the objects. That should avoid your errors.

    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 9, 2015 at 6:05 am

    #1811257

  • RE: Are the posted questions getting worse?

    Okay, I have done my due diligence this a.m. to post both a "worse question" and lots of "worse answers." Feel free to mock and fling porkchops as necessary.

    @=)

    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 9, 2015 at 5:34 am

    #1811249

  • RE: Connectionstring with SERVER=myserverAddress

    philosophaie (7/8/2015)

    I am having trouble with my connectionstring for an SQL Server 2012 on my Windows Server 2012 R2 machine.

    http://www.connectionstrings.com/sql-server-2012/

    Having trouble with myserverAddress.

    What belongs there with SQL Server 2012?

    DRIVER=SQL Server...

    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 9, 2015 at 5:33 am

    #1811248

  • RE: SSIS Transfer SQL Server Objects Task

    What specifically is the error?

    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 9, 2015 at 5:32 am

    #1811247

  • RE: Constantly growing Version Store

    tempdb will always grow and shrink depending on what operations are accessing your different databases. This database keeps all the variables, temp tables (including table variables), and "in memory" calculations...

    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 9, 2015 at 5:31 am

    #1811246

  • RE: Self Less 2015 Movie This Friday

    Spam reported

    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 9, 2015 at 5:24 am

    #1811243

  • RE: Maintenance Cleanup Task not cleaning up

    Is that just a public note or is there a specific question you're trying to ask?

    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 9, 2015 at 5:23 am

    #1811241

  • RE: SSIS: Dynamic updating of a recordset variable

    logitestus (7/8/2015)

    I am trying to execute multiple file actions (plus parsing those files into a set of staging tables) at separate locations in parallel. I know I can do...

    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 9, 2015 at 5:22 am

    #1811240

  • RE: Handle space between multivalue parameter values in SSRS

    If the values are solely those between the quotes, just use the splitter and change the comma to a space. Problem solved. If the values include the quotes and 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 8, 2015 at 10:11 am

    #1811038

  • RE: Are the posted questions getting worse?

    WayneS (7/8/2015)

    I've lost track... who has the crystal ball?

    http://www.sqlservercentral.com/Forums/Topic1701092-391-1.aspx

    I think the Doctor stole 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.

    July 8, 2015 at 10:07 am

    #1811035

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/6/2015)

    New question: Is the sanity of those trying to answer posted questions getting worse?

    Sanity?

    What is this thing you speak of? Define it in simple terms, 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 6, 2015 at 12:29 pm

    #1810542

Viewing 15 posts - 2,521 through 2,535 (of 9,720 total)