Forum Replies Created

Viewing 15 posts - 211 through 225 (of 234 total)

  • RE: Installing named instance of sql 2005 on sql 2000

    You may have an instance of 2005 on the same server with one of 2000; but you cannot have a 2005 instance "on" (or in) a 2000 instance.  These are...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Error: 3411, Severity: 21, State: 1.

    From an MSDN forum, Kevin Farlee says:

    The issue is that the backup app is not properly restoring master.  Most likely it failed to back up the file because it was...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: DTS Headaches - Copying over table

    you might try looking at SQL Server 2005 transaction isolation levels.  In oracle you can violate the RI within a transaction (i.e., between begin/commit) as long as with the commit...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Moving to new server

    Just curious, why do you run rskeymgmt on both the old and new server?  shouldn't the key you kept when you installed on the old server still be the key...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: UPPERCASE DATA

    Not sure why you'd want that except to make searching easier for programmers.  If that is your desire you can install SQL Server for it to NOT be case sensitive. ...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Certificate Trust Lists (CTLs)

    I wrote an article for this site about six months ago on installing with certificates... not specifically CTLs; but the tips for editing the files, and a link to an...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Invalid Descriptor Index. The step failed.

    google it.  the message appears to be associated with a lot of failures.  You will probably have to look for additional errors or symptoms.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: The ordinal 29 error

    SQL Team. com gives the following (per Jasper Smith):

    Stop All SQL services (if started), copy odbcbcp.dll from the SQL Server install cd (in \X86\SYSTEM) and replace the...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: The ordinal 29 error

    The DBFORUMS site lists the following:

    Very Simple Solution...

    Go to WinNT folder under root directory... and search for the file...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Duplicate Users

    There are also scripts on this site (and most SQL sites) for fixing the "orphaned users" that you describe.  I would guess they they use the procedures specified above; but...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Exploring SQL Server 2000 Configuration Properties

    woman!

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: SQL 2000 Replication Architecture

    You get the credit in my book!  Very good article on replication.  It seemed oddly familiar though so I did a few google searches and found out that not...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: RS2005: Failure sending mail: Retrieving the COM class factory for component...

    Sounds like you have not configured the Exchange or SMTP properties properly within RS.  Sorry I can't be more specific but I do not currently have a copy of 2005 running. ...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: Backup Encryption Keys using rskeymgmt error:The local NT Service is disabled 0x80090005

    turn on the service that it says is not running... I believe it is DTC Coordinator, or something to that effect.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • RE: log shipping

    a "standby" instance of a database is not an "active" copy.  There is no technical reason why you can't do what you describe; but you will need a separate instance...

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

Viewing 15 posts - 211 through 225 (of 234 total)