-
Do you have any idea approximately when MS & Marathon will have the capability of clustering completed? This question is from the Microsoft Virtualization Chat held on August 27th.
Last updated: -
Help on Bulk insert and xp_cmdshell rename
Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...
Last updated: -
How do I Autopopulate a few field on my my form?
I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...
Last updated: -
How can I reset a sequence in Oracle?
Does anyone know how to reset a sequence in Oracle? I know that in PostgreSQL, I used this: ALTER SEQUENCE serial RESTART WITH 0; Is there anything like this in Oracle?
Last updated: -
How do I duplicate or clone a dying SATA drive?
If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.
Last updated: -
DB2: Optimizer not using any indexes
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?
Last updated: -
Bundling MySQL Community Edition
Is it free to Bundle the MySQL Community Edition within our Product or along with our Product CD/DVD? Do we need expose the source of whole application software or product to the community? Our product is our main bread/butter of the company. Let me know what options are avaliable and how to do it.
Last updated: -
Catching an uncaptured error in SQL
This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...
Last updated: -
How to convert a csv file into a xlsx one?
Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks
Last updated: -
Can we use count on count or avg on avg for aggregate functions?
Can we use count on count or avg on avg? Meaning can we nest the aggregate functions...if yes...then how?
Last updated: -
Trigger for DB2 user administration
Hi guys, I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. Please help me. If these is possible using trigger then please tell me how? Thanks Amar
Last updated: -
Database hanged due to concurrence
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...
-
Inserting multiple rows in Oracle 10g
I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...
Last updated: -
Customizable IT software for examination process and question database
Thank you in advance for your helpful replies. I am interested in hiring an IT company to create a custom software that facilitates the examination process we offer at our school. However, I am unsure of what exactly is needed so I was hoping for assistance: The goal is to have an online secure web...
Last updated: -
Convert OpenOffice Base to Microsoft Access
Is there a way to convert an existing OpenOffice Base database to MS Access?
Last updated: -
How do I filter a form based on a value contained in the subform?
Last updated: -
How can I split CSV strings in Oracle 9i?
I'm trying to to split several CSV strings in Oracle 9i but I'm running into a few issues so I have a couple of questions: Is this possible in Oracle 9i? Do I need to create a new data type? Would I be able to declare the type within the function? Thank so much!
Last updated: -
MS-Access linked table to AS/400 file – can’t retreive field descriptions/headings
I have created a linked table in MS-Access 2003 over an AS/400 file. It works pretty well so far. The problem I have is I only get field name and type. I don't get any field description or heading information form the file. Any suggestions on how I can retrieve the descriptive info as well?
Last updated: -
Cloning C and G drives on Windows Server 2008
I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?
Last updated: -
Flat file or Physical file in as/400?
How to know whether a file is physical file or flat file in CL/400?
Last updated: