Forum Replies Created

Viewing 15 posts - 631 through 645 (of 9,715 total)

  • RE: Cannot drop the user 'dbo'

    ....AND I own an endpoint for the HAG. When trying to fix it, I get "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.".

    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.

    September 24, 2018 at 8:23 am

    #2006745

  • RE: Cannot drop the user 'dbo'

    Oh, wow. This is really weird.

    When I looked in the GUI, my view said my login was mapped to database A. When my coworker looked 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.

    September 24, 2018 at 8:15 am

    #2006741

  • RE: Cannot drop the user 'dbo'

    Oh, bother. I wonder if I granted IMPERSONATE or some other permission that's screwing this up.

    I need to check.

    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.

    September 24, 2018 at 7:51 am

    #2006734

  • RE: Cannot drop the user 'dbo'

    Lynn Pettis - Monday, September 24, 2018 7:41 AM

    Brandie Tarvin - Monday, September 24, 2018 5:38 AM

    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.

    September 24, 2018 at 7:46 am

    #2006733

  • RE: Cannot drop the user 'dbo'

    Beatrix Kiddo - Monday, September 24, 2018 6:46 AM

    Ok, so you're only permissioned as a sysadmin, then (through membership of that group)....

    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.

    September 24, 2018 at 6:49 am

    #2006724

  • RE: Cannot drop the user 'dbo'

    Beatrix Kiddo - Monday, September 24, 2018 6:09 AM

    What do you get if you run xp_logininfo [domain\yourpersonalaccount], @option = 'all' ?

    account name type privilege mapped...

    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.

    September 24, 2018 at 6:37 am

    #2006719

  • RE: Can db_ddladmin role permissions be limited to specific tables on a schema?

    Jeff Moden - Monday, September 17, 2018 9:36 AM

    HookSqlDba7 - Sunday, September 16, 2018 7:53 PM

    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.

    September 24, 2018 at 5:50 am

    #2006708

  • RE: High Availabilty Group SQL Ser 2012 Trouble

    Rick-153145 - Friday, September 21, 2018 4:12 AM

    You haven't really given enough information for an answer. ... How are you trying to add...

    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.

    September 24, 2018 at 5:42 am

    #2006706

  • RE: Hide multiple Columns based on Parameter value in SSRS 2004

    Kinjal BI - Thursday, September 20, 2018 1:19 AM

    Divya Agrawal - Thursday, September 13, 2012 6:59 AM

    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.

    September 20, 2018 at 4:20 am

    #2006397

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, September 19, 2018 10:45 AM

    What is so hard about creating a Cartesian Product?

    Besides the fact that I can...

    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.

    September 19, 2018 at 10:49 am

    #2006306

  • RE: Are the posted questions getting worse?

    I'm cruising through job activity monitors to look for something specific, when I run into (on a couple of different servers) jobs that me and another member of our team...

    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.

    September 18, 2018 at 10:17 am

    #2006162

  • RE: Are the posted questions getting worse?

    Michael L John - Thursday, September 13, 2018 2:42 PM

    I just deployed a 14000 line update statement. The code needed 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.

    September 14, 2018 at 4:38 am

    #2005726

  • RE: Are the posted questions getting worse?

    Sergiy - Wednesday, September 12, 2018 7:50 PM

    Brandie Tarvin - Wednesday, September 12, 2018 8:53 AM

    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.

    September 14, 2018 at 4:33 am

    #2005725

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, September 12, 2018 7:08 AM

    /me sneezes violently and uncovered in Brandies direction
    *sniff* sorry about that...
    :hehe:

    Thanks
    BTW, good 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.

    September 12, 2018 at 8:54 am

    #2005442

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, September 12, 2018 8:44 AM

    One of these days, I'm going to break down and try JD...
    Just to see...

    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.

    September 12, 2018 at 8:53 am

    #2005441

Viewing 15 posts - 631 through 645 (of 9,715 total)