Forum Replies Created

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

  • RE: MSCS or Veritas VCS?

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

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

  • 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?

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

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

  • RE: PINNED OBJECTS

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

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

  • RE: SYSADMIN PERMISSIONS SQL 2005

    System Center Configuration Manager 2007?

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

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

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

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

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

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

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

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

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