Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 9,720 total)

  • RE: Login can't be deleted because it granted permissions

    Lynn Pettis (3/25/2016)

    Brandie Tarvin (3/10/2016)

    Grr. Having this issue with another login.

    This login does NOT have sysadmin and can't create endpoints. In fact, when I run all the code, I...

    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 28, 2016 at 4:16 am

    #1867922

  • RE: MSDTC / AlwaysOn

    TheRedneckDBA (3/27/2016)

    I saw those references saying MSDTC isn't supported with AlwaysOn 2012. But apparently Microsoft still supports MSDTC itself, because I ended up opening a case with them and...

    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 28, 2016 at 4:00 am

    #1867921

  • RE: How do I install AdventureWorks in my local PC

    When SQL is installed, it generally asks for the accounts of the local sysadmin. If SQL was installed on the machine before you got it, then it is likely no...

    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 25, 2016 at 5:46 am

    #1867715

  • RE: Need help with installing SQL server in my local machine

    mw112009 (3/24/2016)

    I didn't mean to .. The previous post suddenly stopped. Probably Lowell gave up on me. No one was interested anymore. So had to add another post to get...

    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 25, 2016 at 5:39 am

    #1867713

  • RE: Always On

    The cluster MUST be a Windows cluster, but you don't have to have SQL clustered in order to use AG. You can have a SQL cluster use AG, but ......

    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 25, 2016 at 5:37 am

    #1867711

  • RE: Are the posted questions getting worse?

    Yikes! Are you a Verizon customer? You may have had your data hacked.

    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 25, 2016 at 5:30 am

    #1867709

  • RE: Are the posted questions getting worse?

    All,

    I've been having some login trouble on our new SQL 2012 servers. Old logins that I'm trying to delete from databases are not deleting and I don't know 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.

    March 25, 2016 at 4:40 am

    #1867704

  • RE: Access via domain\account OK BUT Access via domain\group DENIED

    Pete Softown (3/24/2016)

    I've asked to change the scope of the DOMAIN_B\GROUP_1.

    According to this article, its supposed to be possible

    https://technet.microsoft.com/en-us/library/cc755692(v=ws.10).aspx.

    Thanks all 🙂

    You're welcome and thank you for adding...

    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 25, 2016 at 4:18 am

    #1867696

  • RE: Are the posted questions getting worse?

    To those who celebrate: Happy Good Friday.

    Of course, you won't see this until next week probably (given how many people are off), but still. @=)

    EDIT: I suppose I should put...

    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 25, 2016 at 4:17 am

    #1867695

  • RE: Data Tools vs Data Tools for Visual Studio?

    GAH! Of all the freakin' stupid M$ crap...

    I'm looking in the wrong toolbox. http://www.jamesserra.com/archive/2013/01/ssis-2012-empty-toolbox/%5B/url%5D

    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 24, 2016 at 12:10 pm

    #1867567

  • RE: Access via domain\account OK BUT Access via domain\group DENIED

    Lowell (3/24/2016)

    ok, i'm going through the same issue as well, we have two domains with two way trusts.

    the network guys tell me it's not possible to change our existing...

    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 24, 2016 at 11:51 am

    #1867558

  • RE: Are the posted questions getting worse?

    Sean Lange (3/24/2016)

    Alan.B (3/24/2016)

    Brandie Tarvin (3/24/2016)

    <headdesk>

    One of my coworkers just came up with the worst joke ever.

    Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn'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.

    March 24, 2016 at 11:37 am

    #1867546

  • RE: Data Tools vs Data Tools for Visual Studio?

    WHug (3/24/2016)

    I'd stop using VS 2010 altogether.

    Here is the link to download SSDT-BI templates for Visual Studio 2012, its a different product:

    https://www.microsoft.com/en-us/download/details.aspx?id=36843

    I already have this. There's nothing in 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 24, 2016 at 11:29 am

    #1867542

  • RE: Linked Server issue

    Siva Ramasamy (3/24/2016)

    Thanks for your time to answer my question Brandie,

    Let me check with them.

    I have made sure that other linked servers from the source server is connecting...

    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 24, 2016 at 11:27 am

    #1867538

  • RE: SSIS Script Task missing a .vb file

    Brandie Tarvin (3/24/2016)

    PB_BI (3/24/2016)

    Have you tried just copying the code out of the task and putting it in a new one?

    I have not. And now I will. Thank you for...

    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 24, 2016 at 11:24 am

    #1867537

Viewing 15 posts - 1,921 through 1,935 (of 9,720 total)