• Upgrade from MS SQL Server 6.5 to SQL 2000 Fails

    The upgrade process using Microsoft "SQL Sever Upgrade Wizard" fails at the "Import and Export via Named Pipe" part. With the following Error: Starting MSSQLServer............................... Waiting for recovery. Sysmessages # 4002 [Microsoft][ODBC SQL Server Dirver][SQL...

    HenryKafeman0 pointsBadges:
  • ORA-03113 error while compiling Oracle packages

    Hi All Recently we migrated our PLSQL code from Oracle 8.1.7.0 to 9.2.0.4. While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and...

    Boball0 pointsBadges:
  • web site built on sql server

    hello we had a person develop our website using sql server. we want to transfer that to an in house server and host our own website. the webserver is in our dmz zone off of our firewall. the sql server is on the same machine. we can not connect to the sql server to update data from our internal...

    Schuit0 pointsBadges:
  • Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?

    We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files...

    Onilke95 pointsBadges:
  • SQL Server ODBC Configuration

    I've got an NT web server in our DMZ that can't connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can't find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going on?

    Rmartinez780 pointsBadges:
  • MS SQL Server 2000 and memory management

    I'm wondering why memory management even, in the newest versions of MS SQL Server (e.g SQL Server 2000), seems to be working very poorly. I'm facing problems with memory usage in a 5-10 user environment (3-4 simultaneous users). An VS.NET based application (iScala) is being used during working...

    KajBre0 pointsBadges:
  • database server needs to be reloaded with software but database is intact

    We have an intact database but lost the server. What method can we use to reestablish the database to the SAP database server?

    BasisDBA350 pointsBadges:
  • SQL Server DB Backups and Transaction log fileseize

    I have a DB that has a DB filesize of 6 gb and a transaction log filesize of 66gb!!!! This DB has a potential for alot of growth because it holds scanned documents for retention and they are in the process of scanning in several years worth of documents from what I understand. I have my maintenance...

    Jpotucek0 pointsBadges:
  • MIgrating SQL Server 2000 to Active Directory

    When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working...

    Jpotucek0 pointsBadges:
  • How to alter more than one existing columns in SQL 2000 Server?

    I m working in SQL Server(2000) Enterprise Edition.When I m using "Alter Table <tablename> Alter Column <column name> (column definition)" for only 1 column then its working (using Query Analyzer). However when I m trying to alter more than 1 column, Query Analyzer is giving error...

    Bakash0 pointsBadges:
  • OBJECTIVE comparison (with independant references) between MS SQL and Oracle 10g

    Morning all, I'm looking for links or actual documents comparing these two RDBMS's that do a good job of keeping their points "personal preferance bias-free". Gartner often is expensive and was hoping for other avenues of comparison. The focus I'm looking towards are comaprisons between:...

    Scorn2420 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl69,920 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server-2

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl69,920 pointsBadges:
  • Uninstalling Oracle 9i products from a Window Server

    Hello how is everyone today? When your removing all Oracle components and services from a Windows 2003 Server what method is used more. The manual method or using Universal Installer? Can you please provide me a link to white papers that take me through the process of using the Universal Installer...

    Bobby40 pointsBadges:
  • SQK Server 2000 Database Size

    I am an Oracle DBA starting to learn SQL Server (as I am sure many are). I have databases that show a lot of free space when I look at Taskpad view. I read that a database cannot be shrunk below it's original creation size, how do I find that original creation size?

    Oradba130 pointsBadges:
  • SQL Server Install

    I just installed SQL Server 2000 on a brand new Windows 2000 SP4 server. The install did not prompt me for the CD-Key! Does anyone know why this would happen?

    Oradba130 pointsBadges:
  • DTS FTP taks with proxy server

    Hi all. Our institution has FTP traffic going through a proxy server. I can get here ftp://ftp.geneontology.org/pub/go/doc/GO.xrf_abbs just fine through Internet Explorer but NOT using an FTP task in DTS. So... does the FTP task basically ignore your IE connection settings? Thanks for info.

    Hopkihc0 pointsBadges:
  • best practice for SQL Agent account security

    Hello... kind of a "newbie" question here, but appreciate the insight. In order to bring our systems in line with best practices, I'm changing a couple of SQL instances from running under LocalSystem to running under a specific account. Same goes for the SQL Agent. Note that these accounts are...

    Hopkihc0 pointsBadges:
  • Creating a Sequence of Transaction Log Backups

    What is the best practices for creating daily (hourly) transcation log backups? Option 1: Create individual jobs for each hour written to individual backup files? Example: log0800am.bak log0900am.bak log1000am.bak so forth Option 2: Create two jobs: (1) first job initiates backup file WITH INIT;...

    Ericggordon0 pointsBadges:
  • SQL Server Books

    I am an Oracle DBA learning SQL Server. Does anyone have any favorite books for SQL Server 2000. I am looking specifically for books geared towards everyday tasks performed by a DBA.

    Oradba130 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following