Command line SQL for SQL Server

[CylonLove4Life]

Hi. I've been asked to do some work on a SQL Server, remotely via a VPN.

I'd like to be able to issue basic SQL commands to it via some type of command shell. Things like CREATE DATABASE etc.

I don't need any GUI's, just a way to issue commands to the server remotely, preferrably from a command shell. I don't have any of SQL Server installed on my workstation.

Can anyone help me?

 

[gmmastros]

You have several options.

This link shows you how to use osql (the command line utility for sql server).

http://support.microsoft.com/default.aspx?scid=kb;en-us;325003

If you don't have the osql utility on your computer, you could download and install MSDE2000 which will install osql on your computer.

http://www.microsoft.com/downloads/...2C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en

You could install SQL 2k5 express which will put a GUI app on your computer that will allow you to issue SQL commands.

http://www.microsoft.com/downloads/...b5-0b07-4448-8848-dcc397514b41&displaylang=en

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[CylonLove4Life]

Thanks! Couldn't have asked for more.