Solved

OSQL installation

Posted on 2010-09-13
2
944 Views
Last Modified: 2012-05-10
Hi;

My application require "osql.exe" to backup SQL database from SQL2005 server, how can I install "osql.exe" on to the application server without installing the entire package of SQL 2005?

I tried to select the Client Management Tool only from SQL 2005 Cd but does not work.
0
Comment
Question by:KANEWONG
2 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 125 total points
ID: 33665534
OSQL is specific to SQL 2000.  You should be using SQLCMD for 2005+.
0
 
LVL 8

Assisted Solution

by:mustaccio
mustaccio earned 125 total points
ID: 33665866
You can download the command line client (SQLCMD, as BrandonGalderisi mentioned) from the feature pack page at http://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=enhttp://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

You will need both                         SQLServer2005_SQLCMD.msi and                         sqlncli.msi (native client libraries).
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL help 5 56
Sql Permission 6 65
passing parameter in sql procedure 9 65
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 65
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question