I'm just trying to get started...

I have MSSQL 2000 MSDERelA (free desktop version, doesn't include the gui front end). I don't have permission to install 2005 Express, but am happy using command line if I can just figure out how.

I've typed some basic scripts (text saved as .sql) to create and define some tables, but how do I execute them?

And/or... Do you know where to find (or can you suggest how to search out) "beginner" mssql info that doesn't assume the gui interface?

Thanks...

-Nancy

-Nancy

To execute a script from the command prompt, you will use the osql command. Try searching for this command in Google to get more information on how to use it or simply type "osql /?" to get the parameters that you need to pass to it.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

Thanks for your help... I got it now.

osql -S localhost\instance -E -i script.sql

-Nancy