Hopefully this is the correct place to post this. I restarted my Windows 2003 Server and i always check the event viewer and these 2 errors popped up.
The Pervasive.SQL 2000 (relational) se...
Hello Experts,
I know that we can write store procedure in Sql server, but is there any way to write store procedure in MS Access.
My front end is designed in VB6.0 which is getting para...
How can I solve this security problem that MBSA is reporting?
Guest Account
The Guest account is enabled in 1 databases.
The database is distmodel
One of our developers told me t...
Hi there
I have a table that forms a relationship between two tables stopping an many 2 many. I was just wondering how could I validate the table when an insertion was done. I am specifical...
I have an error ORA-02291 and a FRM-40735 I need to know what these errors mean. Is there a place on-line where I can find this information?
Is there function in sql server to do an ORDER BY in EBCDIC sequence?
The main features of the EBCDIC sequence are that lowercase letters are sorted before uppercase letters, and uppercase ...
Dear DB Expert,
I have following two tables in MS SQL Server.
T1 (id,name,age,email,salary,jobid)
T2(jobid,title,salary)
where jobID of T2 is foriegn key in T1. The second point to be n...
SELECT Customer_item_name, sum(Quantity) AS All_Item
FROM msc_sup_dem_entries@APS1159
WHERE publisher_order_type_desc like 'Order forecast'
AND TO_CHAR(Receipt_Date, 'YYYY') = '2004'
GROU...
hello.
For performing tree walking in Oracle we use start with, Connect by and "Prior" in Select query...
can you please provide me little explanation of all these 3 key words.
Thanks a ...
Simple question, Im sure i know the answer but I wanted to check with an expert just in case.
A client has updated their application from an older version, this was before my time with the ...
I have a table with loads of duplicates (not real ones, but like with a "-" in one and not in an other etc ...)
So, the comapy names are differents, but the phone number is the same.
I w...
Hi.
I need to extract data from an old DBMS called PI/Open, it was manufactured once from Informix and some time ago IBM bought it and now they are replacing it with a new one called UniVerse...
I need to create reports as follows:
Weekly reports all data should pull for the prior week
Monthly reports - all data should pull for the month that the user selects or enters
Could you ...
I need to use a correlated subquery with alieases. I have been able to make it work when the FROM clauses are simple tables. I can't make it work when the FROM clauses are joins:
What I w...
Hi all,
I have a friend sending me a backup SQL database with extension .bak Im trying to look for a way to import into local SQL database. Can someone please help me?
The back up fil...
The size of my transaction log file is out of control. I've backed up the database and the transaction log went from 120 GB to 120 MB. Now, I can't reduce the size of the transaction log fil...
I have graduated (?) from "MyODBC: Not Found. Driver 3.51 Not Found" (or something very similar) under "MyODBC" in the WinMySQLadmin Environment Tab to:
------------------------------------...
What is the difference between constraints and triggers in sqlserver?
I installed Oracle 9i Ver 9.2.0.1 database and the Oracle warehouse builder 9.2.0.2.8 to a Windows 2000 server and installed OWB Repository Assistant. When I try to install OWB Runtime assista...
We have database files wich end on idx the other files in de same directory have no extensions.
What kind of database is this.
We have to replace an old program for our program, and the cu...
Please can anyone help me doing the following:
-am using PHP code in which i use MySQL to run queries in sokkit
-i cannot run queries where i want to get the result of subtracting a table fr...
Hi,
Am interested to know all about Migration. Could the experts share some knowledge on types of migration, how to do it? How is it different from Porting?
Thanks,
J.
Hi,
we are using DacEasy Accounting and would like to make use of the Accounting information on our Intranet, in order to get some useful combinations of data from both sources.
How can ...
I am having a problem with the following ActiveX task running via SQL Server Agent with SQL Server 2000 which is in turn running on Windows 2000 Server.
Set connPo = CreateObject("ADODB.Con...
Hi,
I will need to update a table to certain values in the beginning of every month.
Does anybody know how I can make use of the DBMS_JOB package to do that? Every week can be handled b...
