Questions & Answers

  • Export XML from SQL Server 2000

    We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?

    JHM5 pointsBadges:
  • MIMIX Basic Concept

    Hi Guys, I want to know how does MIMIX Replicate objects from SOURCE(LIVE) to MANAGEMENT(DR) system. I know there are DATAGROUPS each Data Group has USER LIB  under it and Each DATA Group is attach to a JOURNAL created in the MIMIX. But when you see Data Group of IFS Folders AND User profile and...

    BISHT321245 pointsBadges:
  • What is the recommended Temperature and Humidity range for data center?

    What is the recommended Temperature and Humidity range for data center?

  • Queue Depth

    How to clear the queue depth in queue?

    Ckishorekumarr25 pointsBadges:
  • New to IT Industry, looking to get a job as a Junior Network Associate Position

    Hi, My goal is get a job as a Junior Network Associate Position. Right now, I am enrolled in Cisco Academy Course for CCNA and also I am taking A+ Certification Courses. Am I heading towards the right path? How should I proceed for the job as a Junior Network Associate Position.

    Majidsyed2001015 pointsBadges:
  • Error In SQL SERVER DataBase

    am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help me. i am...

    SrimanBenivolent5 pointsBadges:
  • Spam Protection

    What is the best way to stop spam?

    Sharara30 pointsBadges:
  • Oracle 10g terminated_with_error

    While I'm running an Oracle 10g report using the following code: declare   repid REPORT_OBJECT;   v_rep VARCHAR2(100);   rep_status VARCHAR2(50);  BEGIN   repid := FIND_REPORT_OBJECT('REPORT1');   SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms');...

    K197070 pointsBadges:
  • Exchange 2003 mailbox move

    I created (On a separate drive on the same server) a New Group, Store, and moved a couple mailboxes. I did this because my primary drive only has 2.75Gb left. I moved 3 boxes totalling 8Gb. On the new drive, it showed that I now occupy 8Gb of that drive with Exchange data. However, on the old...

    JeffITman5 pointsBadges:
  • How to Schedule jobs in DTS in sql server 2000

    I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

    SRI HARSHA10 pointsBadges:
  • Ping packet size to save bandwidth

    I want to Ping continuously to my WAN Link Gateway from my system to know the availability & reach-ability of the Link. If I am doing so then certainly it will consume some precious bandwidth. So my question is, what will be minimum possible optimized value of a Ping packet So as to save...

    Dhavalpatel1235 pointsBadges:
  • Windows 2003 Authority

    How can I setup my Help Desk Tier 1 administrator to be able to reset passwords and unlock workstations? This user currently has "standard user" access privileges. Thanks in advance for your response.

    Badger095 pointsBadges:
  • DISTINCT in sql

    what are the features of DISTINCT other than eliminating duplicate values,does it allows NULL values more than once?

    DISTINCTinsql5 pointsBadges:
  • IT training for career switch

    I'm 45, injured, told I must choose a new career. My current job was an all around mechanic/electrician fix it guy. While I have been off I have been repairing, upgrading friends computers, desktops, laptops, etc. I enjoy it but I don't want to waste my time in a basic coarse. Any ideas would be...

    dmdonjuan15 pointsBadges:
  • “Stuck Email”

    I am using Exchange 2003 Outlook 2003  in exchange mode. A few weeks ago we had a hard drive crash and had to repair our exchange database because it corrupted.  We did a data repair of the datafile, not a backup recovery. Now I have one user who has one email that she cannot delete! She is a...

    Coop45 pointsBadges:
  • Troubleshooting a DTS job failure on SQL Server

    I have a DTS job that failed on my SQL Server, but it doesn't have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • PK allows null values in progress DB does this reduce performance of SQL statements?

    Hello, Primary Key allows null values in progress database, does this reduce performance of SQL statements?

    Blom5 pointsBadges:
  • Lotus Domino web access

    We are trying to set up a new firewall (sonicw) and new ISP (AT&T). We can't get domino web access to work. Our old fw (checkpoint) and old ISP (verizon) is the only way it will work. We try to switch over and it fails. Verizon holds our MX records, we have requested to be changed, they say it...

    Amaries45 pointsBadges:
  • Maximum rule space in Outlook/Exchange 2003

    Can the amount of space reserved for rules in Outlook be enlarged?

    SonHouse15 pointsBadges:
  • Error when using Microsoft OLE DB for Oracle in DTS Package

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 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