Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 9,720 total)

  • RE: Linked server connection problem if remote login is used

    The login is defined and set up with permissions on both servers (local and remote)?

    And it uses the same password on both servers?

    EDIT: On the General tab, what 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.

    March 10, 2016 at 6:31 am

    #1864212

  • RE: Unable to start SQLAgent - MSDB is Read-Only

    What changed recently? Around the time that MSDB went Read Only or right before.

    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.

    March 10, 2016 at 6:31 am

    #1864210

  • RE: SQL 2005 into SQL SEREVER 2012

    While you might be able to upgrade the packages directly to 2012, I wouldn't recommend it. Enough changed with SSIS between 2005 and 2008 that your incremental step approach 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.

    March 10, 2016 at 6:28 am

    #1864208

  • RE: Are the posted questions getting worse?

    Thanks, all, for the reviews of the presentation.

    While my class is now officially over, I'm debating on the possibility of redoing the presentation for a more real-world push of 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.

    March 2, 2016 at 6:03 am

    #1862364

  • RE: Are the posted questions getting worse?

    As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.

    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.

    March 1, 2016 at 5:59 am

    #1862077

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/29/2016)

    Alan.B (2/29/2016)

    It's not a bad thing for a recruiter to work with the candidate to modify the resume for a position provided everyone is being...

    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.

    February 29, 2016 at 11:57 am

    #1861908

  • RE: Adding quotes to dynamic SQL

    Thanks for clarifying.

    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.

    February 29, 2016 at 6:20 am

    #1861773

  • RE: Are the posted questions getting worse?

    Grumpy DBA (2/26/2016)

    Brandie Tarvin (2/26/2016)

    Grumpy DBA (2/26/2016)

    Sean Lange (2/26/2016)

    You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:

    Well, that's...

    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.

    February 26, 2016 at 12:06 pm

    #1861518

  • RE: Are the posted questions getting worse?

    Grumpy DBA (2/26/2016)

    Sean Lange (2/26/2016)

    You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:

    Well, that's a good thing because...

    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.

    February 26, 2016 at 11:52 am

    #1861510

  • RE: Linked Servers, Views, and Stored Procedures

    Orlando Colamatteo (2/25/2016)

    Brandie Tarvin (2/25/2016)

    ...some OLTP databases reference tables in the Reporting databases.

    How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to by 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.

    February 26, 2016 at 5:33 am

    #1861359

  • RE: Adding quotes to dynamic SQL

    TheSQLGuru (2/11/2016)

    Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then I never have...

    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.

    February 26, 2016 at 4:19 am

    #1861343

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/25/2016)

    I am so glad I don't have any experience, yet, with replication so that I have no idea what SS is trying to do or why he isn'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.

    February 25, 2016 at 9:45 am

    #1861148

  • RE: Linked Servers, Views, and Stored Procedures

    I'll keep OPENQUERY in mind (and discuss it with the Devs) when we fix things, but it isn't going to help me now. My current sticking point is stored procedures...

    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.

    February 25, 2016 at 8:55 am

    #1861114

  • RE: Linked Servers, Views, and Stored Procedures

    Thanks, Grant. I'll look into 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.

    February 25, 2016 at 8:47 am

    #1861107

  • RE: SQL Server Permissions

    Was it indeed corrupted .mdf and .ldf files?

    Regardless, I'm glad you resolved your issue.

    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.

    February 25, 2016 at 8:41 am

    #1861100

Viewing 15 posts - 1,996 through 2,010 (of 9,720 total)