• Calculating drive volumes and data usage on servers

    Ok i'm a newbie.  I need to calculate drive volumes and data usage on about 75 Sun and HP servers to obtain planning data for a complete update and conversion to NetBackup for all servers. How can I calculate Total Disk Space and Disk Space used without having to...

    ITrUS5 pointsBadges:
  • sst and dst login?

    who can enter in to the SST and DST? means only QSECOFR or any other with authorities can enter in to sst and dst?

    Flakek60 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • Should we use Web services to develop this integrated application?

    We are developing an integrated application that will incorporate excel application, access databases and pda applications using visual basic 2005. Problem is whether to use web services to develop the project. This request for help was originally submitted to the Research Assistant on WhatIs.com.

    ResearchAssistant855 pointsBadges:
  • Case Statements SQL

    I'm running a query that returns a specific status code. However, within my query that specific status doesn't always exist and I get a null value. I would like to return another status when that is the case. I can't seem to get the case statement to work.

    Wilso01115 pointsBadges:
  • Distributed transaction error after upgrading to windows server 2003 SP2

    Hi, After upgrading a win 2003 server from SP1 to SP2 we're receiving a "[Microsoft][ODBC SQL Server driver]Distributed transaction error". When we roll it back to SP1 everything works fine again. As far as I can see the MSDTC looks enabled, but are there any settings that are different between...

    Po33mkqr5 pointsBadges:
  • HOW TO READ A CSV FILE IN OBJECT STAR (O*)

    I have to requirements, 1) I need to extract data present in column A from a O* table, which is of of two columns 'A' and 'B'. The field value can be between 14 to 19 in length and numeric and the file should have a comma at the end of each record  ( e.g - the file extract should look like...

    Ari200940 pointsBadges:
  • How do i recover the DB from suspect mode in sqlserver 2000?

    I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

    Sqkservrdb20005 pointsBadges:
  • ODBC Error Message Windows Server 2003

    ODBC error:   "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.."

    Gina35 pointsBadges:
  • Adding Serial Number to an already existing access document

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

    Ansh12320 pointsBadges:
  • crystal report using parameter query

    i am doing one project using (vb6.0 + ms-access + crystal report 8.5) SELECT division_name, sum(Total_value) FROM segment_trans WHERE date between (Param1) And (Param2) GROUP BY division_name; this is my ms-access query (param1 and param2 thease two parameter value.) in crystal report i pass this...

    Srbatcha10 pointsBadges:
  • Large table in ASE 15.0.3

    Hello - I've got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i'm wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There's one date...

    Jyeager775 pointsBadges:
  • DB2 WebQuery: Metadata Error FOC1567

    I'm new to DB2 Web Query. Just starting with the product. In metadata, I'm trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source 'StockKeepingUnit' is not unique The...

    Dlanor20 pointsBadges:
  • Microsoft Access Relationship/Query Question

    I have a database with around 3,000,000 records organized by account number, and another database with 100,000 or so organized by the same account number. I import both these databases into Access, and link up the account numbers… I want to pull data from both databases in order to create a new...

    Highamperage15 pointsBadges:
  • How to Export a MS SQL Image column to a file.

    I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

    KatanaBeach115 pointsBadges:
  • Implementing a DBMS for a company

    I would like to know the basic steps I should take in implementing a DBMS for my company?

    Bigdate15 pointsBadges:
  • Update multiple tabs on an Access form on initial update

    I have 2 main tables, 1 main form and 4 subforms. The subforms all come from the same table. The subforms are in tabular format, and to fit all the fields I put each subform on a seperate Tabs. The Key Control Number ([Key Contl_Num]) is the Field that appears in each subform and on each tab. My...

    RKJohn95 pointsBadges:
  • create a procedure

    i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.

    Shwetamishra5 pointsBadges:
  • database querying question SQLite

    Hi I'm setting up an SQLIte database within my C application that will be used as an intermediate stage in converting filetypes. My design tries to keep data normalized - for example, i have an Entity table, and in that table each entity has an integer type. There is another EntityTypes table with...

    Kreyszig15 pointsBadges:
  • How to calculate logical file size

    Hi, I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields. Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out...

    Gilly40023,730 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