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 |
|
bensdomain
Starting Member
1 Post |
 Posted - 2004-04-09 : 18:51:49
|
| Hi, i have msde installed and would like to know how to run sql and check for results on my machine. Can you guys pls be able to help me out? Thank you in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-09 : 18:55:47
|
| MSDE does not come with SQL Client tools, so you will have to query the data using osql.exe in a cmd window or download a free SQL client tool.Go to Start, then Run, type in cmd and hit enter.At the command prompt, type in:osql -S(local) -EThen hit enter. You are now connected to your database server in the master database. You can now run queries.Tara |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-04-09 : 21:12:12
|
| theoretically, one could download the evaluation version of SQL server to get the client tools. never tried that though...-ec |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-09 : 23:20:01
|
| ??? If you're just using it at home for development, you can buy the developers edition for $50. How cheap do they have to make it? :)If you install the evaluation edition first, then uninstall the server piece and install msde, you can use the tools. You should probably burn in hell if you do this though. IT'S 50 FREAKIN DOLLARS MAN!!!!MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-12 : 12:08:38
|
| You can only use the SQL client tools if you have a license regardless if they still work after the evaluation has expired.Tara |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-13 : 03:21:43
|
Yes, and Euan polices the forum to pick you up on this if you suggest it  Damian |
|
|
|
jora
Starting Member
2 Posts |
Posted - 2004-04-30 : 02:03:06
|
| You can download a new tool from the Microsoft website ([url]http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en[/url]) which allows you to perform basic administration and viewing of table data.Johan |
|
|
|
|
|
|
msde