What is the purpose of osql.exe? I thought it was just a tool that an admin would use to access an Oracle instance data. I am trying to figure out if osql.exe is needed on a system where no user interaction is performed on the database(no development). Is it needed when a user fills out [...]
If you have more information or know of another definition for OSQL, please let us know so that we can review it and add that information to our database.
Every attempt has been made to provide you with the correct acronym for OSQL. If we missed the mark, we would greatly appreciate your help by entering [...]
BCP works ok if you want to store the contents of a table to text file. If you want the contents of a stored procedure it gets complicated. In summary, you must use the stored procedure to fill a table, then use BCP to export the table, and finally you need to clear the table. [...]
At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks, and I often get asked how can you handle such large numbers of databases. This is a short article that will show you [...]
If you have repetitive tasks to run, multiple SQL servers to administer, or a very large sequence of commands to execute, then the OSQL utility may be the tool to use. OSQL is capable of running both scripts and interactive commands. It is started from the command line and can be executed manually or by [...]