• Query/400 not displaying column descriptions for DDL defined table

    We recently updated a file and converted it from DDS to DDL during the process. During testing no one mentioned the column descriptions were no longer displayed when using Query/400. Is there a way to make Query/400 display column descriptions for DDL defined tables?

    DancingInTheMoonlight145 pointsBadges:
  • What would be the best testing ppt to present for a fresher?

    I just wanted to know the best topic related to testing to be presented before the employees of a company.

    sibabrata5 pointsBadges:
  • Backup error when restoring SQL Server database

    A few days ago, I backed up my database that I created on another machine (which was running SQL Server 2012 Express) and I need to restore it on my machine. However, I keep getting this error when I'm trying to do it: Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing...

    ITKE361,880 pointsBadges:
  • How should I start my data analysis?

    I have a database which has machine data (tables like: machine cycles, machine phases and many more ) and I am suppose to analysis this data. Meaning, with the data present in different tables, I have to filter out or rather define standard machine cycles, standard machine phase etc. Hence, can you...

    rakeshmurthy5 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Table that has multiple records for one field

    I have made a database for a school that has Students info, teachers info, parents info, and some other tables. My problem is that I want a table that has subjects that are shared by all students that I print out a report that has students info, teachers info and that table for performance with...

    VinBagz20 pointsBadges:
  • Force replace when backing up SQL database

    We're trying to back up our database using this code: sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" It's been working but there's one little issue: When the backup file already exists, the data gets appended to the file. We need it to replace the file. Is there a way...

    ITKE361,880 pointsBadges:
  • MySQL backup option for Windows Server

    What would be the best MySQL backup option for Windows Server? I need to only backup my data. Also, the backup needs to be done somewhere outside the the server and I would prefer a free option too. Thank you!

    ITKE361,880 pointsBadges:
  • Backup stored procedures in MySQL

    With MySQL, I've been using mysqldump to back it up daily. But how do I store stored procedures? Is it backed up with everything else?

    ITKE361,880 pointsBadges:
  • How to run a MySQL database backup during the day

    We're trying to backup a MySQL database but we need it run during day (so there is a load on the server). We can't have it impact Apache and our other databases that are running on the same server. Can we use the mysqldump command? Appreciate it

    ITKE361,880 pointsBadges:
  • Best way to backup a MySQL server

    Hi experts! In everyone's opinion, what would be the best way to back up a MySQL server? Is there a way to do it that wouldn't bring down the server? Should we just use the MySQL Administrator tools? We appreciate the help.

    ITKE361,880 pointsBadges:
  • Restore SQL Server 2005 database backup over network

    I apologize that it's old software but we're using SQL Server 2005. Does anyone know if we can restore a database backup using Server 2005 over our entire network? We would appreciate any help.

    ITKE361,880 pointsBadges:
  • Backup database in MySQL

    We currently have a 4 GB database that's in MySQL. What's the best way for us to back it up? We have had a few times that we almost lost all of the data. In another question, would there be a way to speed up the backup process in the event we need to recover? I appreciate the help.

    ITKE361,880 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • Automatically backup PostgreSQL database on Linux

    Does anyone know how to automatically backup a PostgreSQL database that's on Linux daily? Thanks so much!

    ITKE361,880 pointsBadges:
  • How to restore MySQL database Windows tool?

    Hello, I have a database already created. Now, I would like to restore a backup copy. Does the commands MySQL -<id> -p <database> < backup.sql delete the existing database and then create a new one or do I have to do the following: Delete the existing DB Create the database Restore...

    9rudolf5 pointsBadges:
  • Microsoft Access: Reports in Custom Groups vanish

    I have a couple different groups under Customs Groups in Access, and more than once now, when I open a Group there is nothing in it?

    Jaljets5 pointsBadges:
  • What database program should we use for our big data?

    We have a bunch of text files , which range between 300 - 400 GB. Here's the format: key1 value_a key1 value_b key1 value_c key2 value_d key3 value_e .... So each line is composed by a key and value. I'm trying to create a database that would let us query all value of a key. But we're having issues...

    ITKE361,880 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 pointsBadges:
  • Access PivotTavle View field level events not firing

    I have created a PivotTable view in Access 2010. I want to allow the user to double-click on a field and trigger an event that updates the underlying data and refreshes the view. This is a no brainer in VBA, but when I go into Design View and try to add code to an event, the event doesn't work. For...

    eswirkal5 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