Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 9,715 total)

  • RE: How to save SSIS package file (.dtsx) in the database residing in the server which does not have BI?

    What Greg said, combined with what ZZartin said.

    If you want your job to use an Integration Services step to run the package, you need to have IS installed and running...

    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: Backups failing with ACCESS DENIED

    Andrei-176105 (9/17/2014)


    Hello,

    I have a bunch of servers (2000, 2005,2008,2012) that run bakups to network filer.

    All servers (and SQL Agents) run under the same domain account.

    This account has full permissions to...

    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 2012 Not Quite a Cert Question

    Steve Jones - SSC Editor (9/10/2014)


    Admin stuff fairly similar in most cases. Lots of T-SQL changes. The Inside SQL Server stuff, especially Itzik's Windowing book are great.

    Thanks, Steve. I'll look...

    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: MCSA sql server 2012 certification while working on 2008.

    thomashohner (9/10/2014)


    I thought the 2008 cert was expired anyway?

    After I posted here, I read an article on MSSQL Tips that said no more 2008 certs would be handed out 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.

  • RE: SQL 2012 Not Quite a Cert Question

    Wunderbar! I'll take a look.

    Thank you.

    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: MCSA sql server 2012 certification while working on 2008.

    It's always better to certify on the latest rather than the one that is about to become obsolete, unless you plan on only working for people who use SQL 2008....

    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: 70-445 Questions and answers

    Shiva N (9/8/2014)


    hi please provide me the Training kit on xxxx@xxx.xxxx

    Go to Microsoft's website for training kit information. You can order one through there.

    By the way, it is a REALLY...

    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: Database in 'Recovery Pending' State -Error 945

    satish.saidapur (8/22/2014)


    Hi

    I have faced same issue after updating SP.

    When the Database take offline and back to online its work fine...

    That 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.

  • RE: Manually failing over a mirror without access to Primary Server

    SQLisAwE5OmE (8/23/2014)


    Hi Brandie,

    "I've created a job to initiate failover of the mirrors in case of database failure"

    Do you mind sharing how you setup the job?

    The job I set up 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.

  • RE: Compare two columns

    Myke85, your code still has the same problem that Tom pointed out. Are you sure that's the code you want to stick with?

    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: Compare two columns

    That is a good point, Tom. And not something even my Theatre of the Absurd code addresses.

    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: Add a total column

    Luis Cazares (8/22/2014)


    I can't relate to the Phineas and Ferb moment. Should I watch more episodes? 😀

    ABSOLUTELY.

    Misc. Person: Aren't you boys a little young for ...

    Phineas: Why, yes. Yes we...

    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: Add a total column

    Luis Cazares (8/22/2014)


    Are you mocking my signature? :ermm:

    I hope that it can create awareness. :hehe:

    I am not mocking the signature. I am drawing attention to something that most people might...

    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: Running report based on current date

    You are quite welcome.

    EDIT: It occurs to me that you might want to substitute "trandate" for GETDATE().

    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: Compare two columns

    ChrisM@Work (8/22/2014)


    Brandie Tarvin (8/22/2014)


    ChrisM@Work (8/22/2014)


    Brandie Tarvin (8/22/2014)


    Chris,

    Why the STUFF() and the XML?

    It's concatenation of values from different rows of the same column, Brandie.

    Split up the email addresses onto 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.

Viewing 15 posts - 3,091 through 3,105 (of 9,715 total)