Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 6,104 total)

  • RE: MSCS or Veritas VCS?

    Yeah, that's not surprising. So far as I am aware, they only support MSCS.

    K. Brian Kelley
    @kbriankelley

  • RE: Finding user login information

    A (2/15/2008)


    Thumbs up. You're a dba and see this poorly designed app. You reject it and demand proper design. Boss says: No, we'll use this app as is (his son...

    K. Brian Kelley
    @kbriankelley

  • RE: MSCS or Veritas VCS?

    This is something that interests me as well. We use MSCS because that's what we have experience with. Have they considered Polyserve as well?

    K. Brian Kelley
    @kbriankelley

  • RE: Finding user login information

    A (2/15/2008)


    'sa' account should be used for administrative purposes only. If a third party application uses sa account, it must be modified to either explicitly ask for user credentials, use...

    K. Brian Kelley
    @kbriankelley

  • RE: Changing Database owner

    George, it's an extra layer of protection should cross-database ownership chaining get turned on by mistake. Not all, makes sense. Keep in mind, the protection isn't to restrict sysadmin level...

    K. Brian Kelley
    @kbriankelley

  • RE: PINNED OBJECTS

    To find pinned tables, you'll have to query properties on each table:

    SELECT OBJECTPROPERTY(OBJECT_ID('table name'), 'TableIsPinned')

    K. Brian Kelley
    @kbriankelley

  • RE: SYSADMIN PERMISSIONS SQL 2005

    System Center Configuration Manager 2007?

    K. Brian Kelley
    @kbriankelley

  • RE: Should the DBA be a Local Administrator?

    The limitation to being administrators is only Windows 2000. The max 2 connections (not including a connection to the console... also a new feature of Windows Server 2003) is still...

    K. Brian Kelley
    @kbriankelley

  • RE: Command Line

    faheemlatif (2/14/2008)


    Hi ,

    Please try this :

    exec master.dbo.xp_cmdshell 'mkdir "D:\temp"'

    exec master.dbo.xp_cmdshell 'dir "E:\"'

    If xp_cmdshell is enabled, these should work. But they don't require an interactive session, like what the poster was...

    K. Brian Kelley
    @kbriankelley

  • RE: Finding user login information

    If you audit logon/logoff events on the server where the app is installed, you can get a picture of who is on the system at a particular time. If you're...

    K. Brian Kelley
    @kbriankelley

  • RE: Blackberry or smartphone for DBA

    I've gone from Blackberry to Smart Phone and back to Blackberry. Let's say that I was less than satisfied with my Windows Mobile experience. But then again, I wasn't trying...

    K. Brian Kelley
    @kbriankelley

  • RE: Should the DBA be a Local Administrator?

    KevinBrenn (2/12/2008)


    But perhaps you should also ponder ... should all local admins( of your server) be or have the same rights as the DBA given that by default local admins...

    K. Brian Kelley
    @kbriankelley

  • RE: Should the DBA be a Local Administrator?

    steve smith (2/7/2008)


    Nicole,

    At a philosophical level, you may not be correct. Practically speaking, you're finding NOT having these rights is a pain in the $@%^&! and slows you...

    K. Brian Kelley
    @kbriankelley

  • RE: Should the DBA be a Local Administrator?

    Q (2/7/2008)


    I have worked in many places that simply gave me keys to the kingdom, domain admin rights. I don't mind having that responsibility, but it opens you...

    K. Brian Kelley
    @kbriankelley

  • RE: Command Line

    You should be running this through a non-interactive interface. Executing IE in this manner does not work, as previously indicated. For instance, script the access using Perl or Powershell and...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 1,336 through 1,350 (of 6,104 total)