Hi
I am very new in OSQL, can anyone tell me how to run the sql scripts in command prompt.I searched for this in net, osql is given there but my login is failed. Plz guide me how to run the script from the notepad from one database to another in network.

Regards
Lily

You can find useful information on book online. Here is an insert from BOL for your particular issue

If you do not specify a user name when you start osql, SQL Server 2000 checks for the environment variables and uses those, for example, osqluser=(user) or osqlserver=(server). If no environment variables are set, the workstation user name is used. If you do not specify a server, the name of the workstation is used.



Jaime E. Maccou

When i am writing as osql -U or osql -P to start osql its asking for password.
How to handle this.

osql /U <username> /P <yourpassword>
If neither the -U or -P options are used, SQL Server 2000 attempts to connect using Windows Authentication Mode. Authentication is based on the Microsoft Windows NT® account of the user running osql.

Books online has the complete syntax and switches to use.

what version of SQL do you have?



Jaime E. Maccou