Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tcarnahan
Starting Member
23 Posts |
 Posted - 2005-09-27 : 15:18:10
|
I am on a new task where I don't have Enterprise Manager available and I need to build a database (I have been spoiled on all prior tasks). I have access to SQL-Server and have OSQL available (and other utilities I don't know how to use). I have already found that I can access the server using OSQL, but I don't know the rest of the parameters for OSQL or how to use them. I need to build tables, relationships, indices, stored procedures, views, etc.Could someone point me to some documentation where I can learn how to use OSQL?Thanks!  |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-28 : 00:27:56
|
| Use Enterprise Manager on another machine and get it script your "actions" and then run those scripts via OSQL on the other machine!After a few goes with that you'll know what to script.Joking apart Enterprise Manager generates good scripts for complicated tasks - like changing the size of a column and the knock on effects of having to create a temporary table, copy all the data across and then drop the original and rename. PLUS dropping all the FKs before, and recreating them after. PLUS re-instating any triggers after - lots to get wrong / forget if you try to learn by just following-your-nose!Kristen |
 |
|
|
|
|
|
OSQL for SQL-Server 2000