Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: Using mount points instead of drive letters

    Oops, I was thinking of files that may get placed on mount points as share folders and such. I'm assuming that since backup software can be configured to travel down...

  • RE: Using mount points instead of drive letters

    Good info everyone (especially the MS link).

    It would appear there is no down side to mount points and even MS recommends them to avoid the dreaded drive letter limitation. My...

  • RE: How many databases is too many

    Thanks for the input. Performance testing would tell me where I am today and continuing to monitor would eventually tell me when I've hit the wall on a given metric...

  • RE: Allow user to view job info fails with access denied

    Thanks for the link. I am having the exact same experience. I compared the certs and they are the same. I ran your test script and get the same error....

  • RE: Is password history enforced

    I am far from an expert but can be like a bulldog refusing to let go. I apologize if I'm beating a dead horse, but,

    I used my SYADMIN account...

  • RE: Is password history enforced

    Does that mean if I connect to an instance with a domain account (w/SA rights) and change the password of a SQL account, the policy is not checked? Doesn't seem...

  • RE: Is password history enforced

    I am changing it using a domain account in the SYSADMIN role but not a domain admin. I also logged in with the SQL account which is in the securityadmin...

  • RE: Is password history enforced

    If I change the password using SSMS does the password history apply?

    It would appear I can use to the same password over and over when I right-click get properties...

  • RE: sp_execute returns error

    Thanks Chris, you nailed it.

  • RE: Latest security patch

    I contacted MS tech support and they indicated the hotfix can be applied to servers running Windows 2000 SP4.

    Hope this helps.

  • RE: Latest security patch

    Thanks for the info.

    I am running on Windows 2000 server. The hotfix indicates it only supports these OSs:

    System Requirements

    Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP

    Windows 2003, Vista,...

  • RE: Disaster revovery when no master database

    Success

    In order to restore an instance when there are no system databases except in backup form:

    Copy system databases from another instance to the exact location where the instance expects to...

  • RE: Disaster revovery when no master database

    Progress....

    I was able to get the instance up by:

    Copying all the system db files from another instance

    starting the instance in single user mode

    restoring the last master db backup

    Now, when I...

  • RE: Disaster revovery when no master database

    I am at a loss about how to do disaster recovery. I have followed everyone's suggestions but nothing has worked. I consider this to be a very serious matter since...

  • RE: Changing service account password on a cluster

    I'm amazed I can't change the password on one node and have it propagate to the other nodes. It works fine in SQL 2000.

    MANU (6/3/2008)


    It looks you have to manually...

Viewing 15 posts - 1 through 15 (of 25 total)