• How to rename a MySQL database quickly

    How would I be able to rename a MySQL database quickly? Most of the time, I usually just dump the database and re-import it with a new name. But since this is a huge database, this isn't possible. Can anyone help me here?

    ITKE352,485 pointsBadges:
  • Database management advice

    I'm an IT student from tanzania. Currently I'm an intern in one of the united nation org. but I'm only doing user support activities. But I want to build my carrier in database management. Can you give me some advice on where to start and what to study?

    1234567915 pointsBadges:
  • Auto Replace Text in a table

    Is there a statement I can add that will automatically replace a text string with another string? EX> NORTH CHANGE TO BILLY BOB THROUGH OUT A FIELD

    Dapostman5 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • Error in SQL coding

    I am having a specific problem with coding in SQL, and I was curious if you could give me any advice. I have entered this code: CREATE TRIGGER UpdateAfterPayment On SupplierTransactionDetails For Insert, Update, Delete As Update S If i.DebitValue>0 S.Balance = S.Balance + i.DebitValue else...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Access Reports to PDF file

    Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one PDF file through VBA. Access 2007 has easy way to convert one report at a time to PDF, however, I cannot figure out how to...

    SeenFresh25 pointsBadges:
  • Create .csv file on IFS folder in AS/400

    Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

    Samule400160 pointsBadges:
  • MS Access 2007 mass email list?

    I was wondering is there a way to create a mass email from a query or table that would send out in MS Outlook? I know of a way of extracting a table and importing it into Outlook but my boss wants a more efficient way.

    Itguy1509220 pointsBadges:
  • FTP transfer from iSeries to PC workstation

    Hello everyone! Please help me with this question: Is it possible to send save files from iSeries to PC (Win2000 Server) through some batch program? The idea is to make manual connection and FTP transfer and then to create a batch program which would give possibility to schedule this FTP transfer I...

    Dalibor10 pointsBadges:
  • Cisco Wireless 1200 series access point

    Hello all, does anyone know how to change the DHCP range that a Cisco 1200 series Access point gives out, the IP for the AP is 10.20.x.x, and it give out IP's in the 192.168.x.x range, does anyone know how I can get it to change to the 10.20.x.x range as this is the range that I want the computers...

    CGarcia26C1,025 pointsBadges:
  • How to know that the access list is working

    What command can I use to show that the access control list (ACL) is working?

    NetworkingATE1,545 pointsBadges:
  • Do you have any idea approximately when MS & Marathon will have the capability of clustering completed?

    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.

    ITKE352,485 pointsBadges:
  • 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:...

    GIG240 pointsBadges:
  • 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...

    Lisarod25 pointsBadges:
  • 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?

    ITKE352,485 pointsBadges:
  • 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.

    ITKE352,485 pointsBadges:
  • 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?

    AS400 - Ask the Expert485 pointsBadges:
  • 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.

    Rajeshbs45 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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

    VPD5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following