Re: MSDE 2000 help please

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 15:13:55 -0500

> I can make
> databases by using osql in a command prompt but is there an easier way?

http://www.aspfaq.com/2442

> also where does the server save the databases that i create?

The data and objects are stored in MDF files on your hard drive. They don't
really have any meaning independently (e.g. you can't open them in notepad
or Excel and look at them like you would in Access or other desktop
applications).

> I cant find anything
> on my system after i created a basic db.

Well, what did you do to "create a basic db"? What are you looking for on
your system?

A

Relevant Pages

  • Re: on click error
    ... What I personally do put a text file on the desktop, and include a line for each of the databases I'm working on at the moment. ... Paste into the command prompt, holding down Shift to avoid the startup code. ... Allen Browne - Microsoft MVP. ... you could always create a shortcut with that exact command in it. ...
    (comp.databases.ms-access)
  • Re: corrupt backup
    ... dismount databases stores that you want to ... In command prompt to the C:\...\Exchsrvr\Bin> directory and run the ... > there local drives before I try to repair the database? ...
    (microsoft.public.exchange2000.information.store)
  • Service Pack 3
    ... MSDN tells me to go to a Command Prompt ... >and enter osql -U sa and then enter the password. ... >Hal Fliegelman ...
    (microsoft.public.sqlserver.security)
  • Re: WSS3 SQL2005 - move databases
    ... At a command prompt ... Then you can go into you "Central Administration" / "Application Management" / "Content Databases" ...
    (microsoft.public.sharepoint.windowsservices)
  • Cannot connect to SQLEXPRESS via MS Enterprise Library??
    ... Windows XP ... ..NET 2.0 {for SQLExpress} ... This works from a command prompt ... osql -E -S localhost\SQLEXPRESS ...
    (microsoft.public.dotnet.languages.csharp)