Re: osql command reference?

From: Stefan M. Huber (looseleaf_at_gmx.net)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 17:48:58 +0200

On Mon, 19 Jul 2004 15:57:16 +0530, Hari Prasad
<hari_prasad_k@hotmail.com> wrote:

> Hi,
>
> Books online is the best option to learn all commands and usage.
>
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
> * the complete desciption of BACKUP and RESTORE
>
> See backup and Restore in books online
>
> * a way to show the table definitions.
>
> sp_help <table_name>
>
> * OSQL
>
> See OSQL in books online

Thanks!

And while my other link isn't for MSDE, most of the things discussed there
work in MSDE as well :)

Stefan

Relevant Pages

  • Re: Manipulating MSDE Files
    ... You really should use Backup and restore but if you want to ... I then restarted MSDE and deleted ... > re-install one database from the CD/RW. ...
    (microsoft.public.sqlserver.setup)
  • Re: osql command reference?
    ... Books online is the best option to learn all commands and usage. ... * the complete desciption of BACKUP and RESTORE ...
    (microsoft.public.sqlserver.msde)
  • Re: Backing up MSDE using Vb.Net
    ... check out the BACKUP DATABASE and BACKUP LOG commands. ... order to restore, you'll use the inverse functions, RESTORE Database. ... down and if you have another machine to back it up to, why not just use MSDE ...
    (microsoft.public.dotnet.general)
  • Installing MSDE - User Security Issues...
    ... replicating a SQL Server 2000 database as an MSDE database in a seperate ... using oSQL to restore the database to an MSDE install on a machine. ... It's done in two steps - installing MSDE and restoring the backup. ...
    (microsoft.public.sqlserver.security)
  • Re: dropped tables
    ... We Restored from the last backup 12 hours prior... ... Restore it from a backup if you have one. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)