I have a client which I did a SQL upgrade in August. I hired a SQL Engineer to do that. My client is experiencing issues with the 60 gig hard drive filling up and running out of space. There i...
ok...
here is what i am trying to do.
i have a table with 2 fields. number of games the atheletes played and their points.
i want to state if the following hypothesis is right or wrong.
t...
Dear experts,
i have problems writing an sql statement:
here's my case!!
i have three tables products, table1, table2
products:
---------
productid (autonumber)
productname (text)
...
Hi
I would like to link my application to SAGE Payroll and have read from the web that I can use an odbc connection to link to the SAGE Payrol database.
Does anyone know what this connec...
I have added a column to several tables, and I populate the column using a couple of stored procedures in a huge import process. I am getting this error returned when I run the main stored pro...
Hi All,
I am a newbie to the PL/SQL area. I am trying to generate the XML for a record to insert the data into an audit trail for the table. To do so, I declared a string for VARCHAR2(4000)...
Dear Experts.
Is there much advantages for use the Microstrategy 8? I know that the Microstrategy 8 is to make keeping data, accessing, reporting on data easier for the company. Any thought?
Dear experts.
I was wondering that how business intelligence and decision support database differ from operational database? I think that the operational database is the data collected on a d...
Hello,
I dont work much with DTS packages but is there a way to be able to convert a DTS package into code or some readable format? Here is the scenario, say we have about 100 DTS packages an...
Hello,
I have a table 'Articles' with a VARCHAR field 'WritingDate' which contain these sample lines:
5/4/2003
06/1/2006
5/02/2006
05/02/2006
05/02/2006 10:00:00 AM
Basically I wa...
Hi
At MSDOS command window I issued these command:
set oracle_sid=mxt
exp scott/tiger file c:\oracle\emp\tas.dmp
I am getting these errors
EXP-00056: ORACLE error 12560 encounter...
We have an SBS 2003 server which seems to have three instances of SQLServer running at any one time. I am not quite sure why as we are not using SQLServer for any specific database. However, i...
Hi,
Can someone please provide the link to the technical specifications for a couple of DBMS products. I am also after any information on the licensing methods available to these products i...
I am trying to learn how to create a unique identifer for an SQL database using VB .NET.
Say this is the table, tblMembers in a database designed to track people.
tblMembers has fields
...
We are experiencing an error when installing the SQL Server 2005 Desktop.
Here's the error from the dialog: The SQL Server System Configuration Checker cannot be executed due to WMI configu...
Greetings, all.
I've just been moved to a position where I'll be "owner" of an application (Borland's CaliberRM) that runs on a Versant database. It would probably be a good idea for me to ...
I need to be able to create a script that can check the free space in Cache 5 and 5.1. I have starting using the csession tool but I can't even find basic commands. Can someone point me in th...
I have an AD environment which has many rogue servers and services attached. I am needing to query AD for various databases: SQL, Oracle and DB2. I am unsure if any are registered in AD, but w...
im trying to fix some code that a previous programmer wrote. The goal is to compare two fields and check for discrepancies.
It works if the strings are different, however it doesnt work if th...
Sir, I am using two table for posting my vouchers and I am using following code for displaying ledger of each account
select b.Acc_ID, a.VCreateDate, b.Naration, b.Debit, b.Credit from AC_...
The rman & veritas has been working until July 5 and stoped running. I tried to schedule and run the backup.sh from Veritas scheduler and got the following error in my log file.
RMAN-060...
Hi,
I have a database that contains 2 tables (that im working with)
One is a table that is used by an application we use and contains a list of all usernames for people who have accessed...
Hi i am having an employee table
16:40:33 ops$tkyte@acorntst> DESC EMP
Name Null? Type
------------------------------------------------...
Hi All,
Can any one suggest right documentation on best setup/performance tuning of Sun Solaris 10 for Oracle 10G
Thanks a million,
Milana
Table name= Customers
Field names = Fname, Lname, FullName
I want to issue a command that combines fname and lname into the fullname column seperated by a space.
I also want to do the r...
