• 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?

    ITKE1,072,430 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:
  • 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:
  • 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:
  • 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:
  • Linux file system for MySQL

    What would be the best Linux file system for MySQL? My database is a web-based OLTP (and 90% read). Any help would be appreciated. I'm leaning towards XFS.

    ITKE1,072,430 pointsBadges:
  • FoxPro 2.6 DBFS Security

    in my absence others open my dbfs (eg sales.dbf) in my computer. How to lock the dbfs and how to unlock it for my use.

    Mrvsp5 pointsBadges:
  • MySQL upgrade error: FATAL ERROR: Upgrade failed

    We're currently upgrading our MySQL and it keeps failing on us! Here's what we're getting: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed Anyone seen this error before? If so, what can we do? Thank you.

    ITKE1,072,430 pointsBadges:
  • Access database file corrupt

    i am using acces database but something is happened, my database file is not working properly pls if you have any idea about this problem pls let me know or specific mail me on my e-mail id anteshwar.bhosale123@gmail.com thanks anteshwar bhosale

    192168020120 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