• Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE435,865 pointsBadges:
  • How to save query in Visual Basic

    There's one other thing that might cause a problem. Microsoft Access, if that's what you're using, doesn't support COUNT DISTINCT. (At least, it didn't in Access 97. I don't have Access 2000 or 2003, so I can't test it.) To get around this, just use a saved query, which is the equivalent of a view...

    Habibg7975 pointsBadges:
  • How to fix error in database: Microsoft Office access has detected corruption in this file

    I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact...

    kennethrich047x5 pointsBadges:
  • Disadvantages of in-memory database

    Can someone explain the disadvantages around an in-memory database?

    ArjAbdullah5 pointsBadges:
  • Register a fake certificate

    I would like to ask if it is possible to register a fake certificate of English language into the validation database, i.e. IELTS. Thanks

    mike845 pointsBadges:
  • Automatically update Access table into a database

    I have a access table I want to automatically update into a database. I've linked it through an expression on load but it does not update the database. Where did I go wrong?

    LauraBarrows5 pointsBadges:
  • Wrkqry for join files

    Hi, can you help me how to join the two files but the two fields are not the same length e.g. 1st field (left side) is 9 (ex. A005B2589 job#) and the 2nd field (right side) is 11 (ex. A005B258901... the last two digit 01 is for partial#), kindly advise if it's possible?  Thanks and regards...

    Mario0525 pointsBadges:
  • Are there SAP certifications for database administration?

    Are there any SAP certifications for database administration? If I want to be a database administrator, are there any SAP certifications I should acquire?

    jakanani20 pointsBadges:
  • How do I keep the original value of a field in Access 2010?

    Hello, I have an inventory with varying prices (which may change weekly).  I need to compare the current price with the original price. However, I only want the users to input one price value in a form.  I've tried to do this with a datamacro and the "old" command, but every time i update the...

    Vostro12315 pointsBadges:
  • SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • Fill in cells between specific date range in Microsoft Access

    I have a file where customer's terms changed on a specific date to a specific value. I would like this value to populate for every day until the next change. For example: Customer 12345 was changed to term A on 1/1/2015. Customer 12345 was changed to term B on 2/5/2015. Customer 12345 was changed...

    novice3215 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • How to become an Oracle DBA

    I am a fresher and graduated in electrical and electronics engineering but I want to settle in the IT industry. What skills I need to develop to become an Oracle DBA? Thanks!

    tomcatafroz5 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • What is the best way to delete records omitted from a data feed?

    I have a very dynamic vendor who adds and deletes products daily. They provide major updates twice daily and while they don't provide inventory numbers - just "in stock" and "out of stock" every 15 minutes. Obviously, it is not feasible to update my db every 15 minutes. However, my question is,...

    KRMarquardt5 pointsBadges:
  • How to delete specific files in a folder with Access VBA

    I'm looking to delete all files in a folder, except 3 specific ones. All files in this folder are .csv files, and all of the file names are different. Let's call the 3 files I do not want to delete "Jim.csv", "Chuck.csv", and "Matt.csv". Is there a way to delete all files EXCEPT the ones you...

    JimmyJames10 pointsBadges:
  • Auto populate field in Microsoft Access

    From a two column table, I want to choose from column 1 to populate one field and have the next field populated with column two. How can I do that?

    centerdirector5 pointsBadges:
  • Stop Apache and MySQL from automatically starting up in Ubuntu

    For Ubuntu, I don't need Apache and MySQL to run automatically when I startup. When I boot up, they automatically startup. How can I stop this from happening?:

    ITKE435,865 pointsBadges:
  • Restore MySQL database from .frm files

    I'm in a huge bind. I'm using Windows Server 2003 / MySQL. I have to recover a MySQL database from an old server to a new installation. The server it was running on will no longer boot. So I cannot do a backup. All I have is the MySQL data directory from the old machine. I've stopped the MySQL...

    samaritan0535 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 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.

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

Following