Forum Replies Created

Viewing 15 posts - 976 through 990 (of 6,041 total)

  • RE: Identifying list of users or groups that have create table permission

    Simply querying system tables won't cut it. Check out the sys.fn_my_permissions function which can be used to determine "effective" permissions, meaning it covers permissions inherited by membership in domain, server,...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The CDO

    Steve Jones - SSC Editor - Saturday, April 28, 2018 7:30 PM

    Eric M Russell - Friday, April...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The CDO

    allinadazework - Monday, April 30, 2018 4:25 AM

    Steve Jones - SSC Editor - Friday, April 27, 2018...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The CDO

    Just like the 20th century was the period when companies learned the consequences of industrial pollution, perhaps many companies today will minimize their legal exposure and operational expense by not...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Northwind Database - Creating trading balance between countries.

    margor20 - Friday, April 27, 2018 7:05 AM

    I had some time to work on it, now I have this query:


    SELECT
    MAX(ca.CountryName)...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The CDO

    Chief Data Officer would be sort of a pretentious title for those small and medium sized organizations that don't even have a designated Database Administrator.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Northwind Database - Creating trading balance between countries.

    margor20 - Friday, April 27, 2018 4:21 AM

    I have quite a task to do.
    Using an old Northwind database, I need to...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Database Administration Team Reporting Hierarchy

    It's unclear why the staff who are mostly "Report Writers" would naturally fit into the DBA team, especially if they mostly maintain reports for a specific business unit like Finance...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    If the vendor is stubborn about the configuration, and you have no other choice but to use them, then you can perhaps run their applications and databases inside a VM...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    ajordan 76503 - Thursday, April 26, 2018 8:01 AM

    We have a third party vender that is not quite as bad as all...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    Jeff Moden - Wednesday, April 25, 2018 4:17 PM

    p.s.  I'm going through the drill right now.  Our telephone system vendor has asked...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    If a software application is hard coded to use the "SA" account, you can rename it and then create a new account named "SA" with limited permissions. One or...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    andrew gothard - Wednesday, April 25, 2018 4:01 AM

    And, having worked with numerous third party packages I'm supposed to be surprised by...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Login failed for user 'undefined'.

    Lynn.Davis - Tuesday, April 24, 2018 1:50 PM

    Thanks Erik,
    Our security team does periodically probe our SQL servers, but the error is...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    Lynn Pettis - Tuesday, April 24, 2018 1:32 PM

    Eric M Russell - Tuesday, April 24, 2018 12:31...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 976 through 990 (of 6,041 total)