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 |
|
rajani
Constraint Violating Yak Guru
367 Posts |
 Posted - 2005-09-15 : 16:50:55
|
| hi friendsi installed MSDE on my xp machine.how can i add database to MSDE.i dont see any interface to add.is onlyway ,to use a computer with full sql server installation and connect to MSDE to add databases ?ThanksCheers |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-15 : 17:15:27
|
| If you don't have the SQL Server client utilities installed, then you'll have to use MSDE via the command line. osql.exe is the name of the executable. Type osql /? from a cmd window to see its options to connect. Here is an example:osql -Sserver1 -EThe above says to connect to server1 using Windows Authentication. You'll then get 1> prompt. From there you type in queries, hit enter, type GO, then hit enter to execute. You have to pretty familiar with commands to use osql.exe.Tara |
 |
|
|
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2005-09-15 : 17:22:28
|
| Thanks for quick response Tara.ILL give it a try :)Cheers |
|
|
|
|
|
|
adding db to msde