Hi,
my company is using great plains 8 and Ive been asked to write reports off the database and Im not sure what the fields mean.. Does any one know have or know where to find a data dictiona...
I am using a DTS package to convert information from JBASE3 to Sql.
I have two fields of interest:
Labour Cost: 52.9200
OH Cost: 128.1300
I am dividing these two values by 100 in the...
How can i get the name, num_rows, size of each table owned by a user
I have a Windows 2000 server that is up to date with service packs and updates. After a reboot yesterday, pervasive is no longer listening on port 1583. I do not have any firewalls loaded on...
I have a query in MS Access 97 and/or 2000 that I am trying to read the values from a multiselect listbox (Mylist) on a form (Form1). I set the list box property to Simple. When I ran the qu...
I HAVE MY AUDIT_TRAIL initialization parameter set to TRUE.
nOW FROM SQLPLUS I TYPE THE COMMAND
AUDIT INSERT ON ACORN.EMP
I GOT AUDIT SUCCEEDED.
NOW I DID INSERT ON EMP(EMPNO) VAL...
I am going to install Oracle 10g on AIX 5L. I want to know what memory and init parameters that need to be configured.
Hi Experts~
I have a qry that I am working on that selects information based on peoples schedules. (WFM software). Todays Qry pulls back the Start and End time of an activity and the # of pe...
Everyone,
I have two computers, one with MSOffice 2000 (9.0.3821 SR-1) and the other with MSOffice 2003 (11.8033.8036) SP2.
I have a database that uses a FORM with drop downs and buttons...
This may be vague - but all I know to ask right now....
I have a database that uses an MDW database for security. I have a table in my database with five columns
USRID NAME PA...
Is there a way run a stored procedure on server A that connects to and runs on a database on server B? I've been using a linked server, but isn't going to cut it anymore.
Thanks.
I have a link from a Sybase database to an Oracle database.
We are having an issue converting data for one of the varchar fields. The Sybase field is defined as Varchar with 1000 char limi...
I want to extract column metadata such as column data type, MaxSize,IsPrimaryKey, IsForeignKey.
I tried this but getting null instead of true/false
use Northwind
select COLUMNPROPERTY(O...
Hi
I want to know how do you estimate for an database maintainence projects , what are the key areas to look for ? How do you determine the resources and the timings ?
Regards
manisb
hi there
I have been getting a error in the event logs under application for Sql server. The error message is below
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Eve...
Hello ,
I have read material comparing mysql to postgres etc but alot of the time this information is two or three years and releases old.
I want to have an idea of the differences/advantage...
We have an application which uses the "IISadminpwd" component.
But we need to fix a password problem customers encounter in that module -which forces them to change their password early ev...
Disclaimer: I am an SQL idiot. Everything I have done is copy and paste with the help of others.
I am currently using SQL to query a database located in one application called InfoPlus21 ...
Hello, I am trying to remove DBMS_JOB, but getting error. My DBA is on vocation so I really stuck here.
Here is what I run:
SQL> select job from dba_jobs;
JOB
----------
...
I need to JOIN two mySQL tables, what i have is the parent/master table of inv_inventory and the child table of img_images, ID's for the records inv_id (parent table) and idpar_img(child table...
Our Company has a SQL Database Server which is getting slower day by day, every 3-4 days its stucks up and i have to restart it , after restart it works fine and again gets slower and slower, ...
i have a formula on a report which calculates the total cost of expenses. the formula is =sum([cost]). However, i would like the formula to calculate the total cost of expenses that are not...
table A has 37 fields.
I want query that makes a copy(structure) of TableA and names it TableB, then copies selected rows from TableA to TableB. the selection criteria is based of column1 ...
I am trying to schedule a job to import data from text files into mssql database and this statement fails although the parameters are correctly set:
BULK INSERT Billing..CDR FROM 'f:\CDRs\Wh...
