what concepts should i need to look more. What is the typical day for junior dba? Can you please share your experience. I am really working hard to get DBA position.
Hi,
I am trying to configure MS SQL Server email notifications running on Windows Server 2003. I don't really know how to, so any instructions or obvious requirements that you can point out...
SQLLDR ACORN/ACORN@ACORN control=D:\DbAcorn\TESTLOAD\test_load.ctl, bad=D:\DbAcorn\TESTLOAD\test_load.bad,log=D:\DbAcorn\TESTLOAD\test_load.log DIRECT=Y
This my command line call to sq...
I have a DBF table to convert to MDB (Access).
I need to recover the row number, since it is not in the table already. Also, there are deleted rows.
Access will not import it (error: une...
I'm trying to find documents that have the string "ORACLE 8".
SELECT * FROM CONTAINSTABLE(MYTABLE, MYFIELD, '"ORACLE 8"') ORDER BY rank DESC
The top results (with rank between 100 and 200)...
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 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.
Hi guys.
I have a big problem here
I have oracle 8.1 runing a connection in several bentley design series software
But one of the machines isn't connect via odbc , i can't succed the co...
Hi
My mysql datatbase has row entries with two column headers :-name_of_file and date_modified.
Example:
name_of_file date_modified
pooh.txt 2004-12-04
piglet.txt 2005-0...
oracle syntax---This is urgent for 11.30pm gmt time....sorry
declare
-- Test statements here
/* ------------------------------------------------------------*/
/* Procedure to ...
I have an application that adds some text information to an Oracle DB. I want to let the user fill in a form that appends the new information to the existing information. I've got the form wor...
Hello -
I need to replicate the MSDTC security configuration out to multiple laptops. These settings are found in Step 2 of MSKB 839279 as seen below -
(for full article - http://suppor...
Does any one know the detail for this flag? This is an option in DBCC reindex.
Thanks!
Hello,
Can somebody help me figure out how to start SQL server 2000 seperate instances in singel user mode from the command line?
Thanks!
Hi
I realise that there are a number of postings regarding this subject, and I am normally quite good at adapting code to fit my requirements, but this one has me baffled.
I have a file ...
Hi,
How can I get rid of this error ?
Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
I get this when I try start the mysq...
v2000 latest sp - user only member of the public group, and is member of db_datareader role. How is it possible that he could have just deleted several thousand records from a table he has on...
