MSDE newbie question: contents of default databases

From: Simon Elliott (Simon)
Date: 05/26/04 

Date: Wed, 26 May 2004 08:09:46 -0700

Having installed MSDE and connected to it, it seems there are several
default databases already:

master
model
msdb
tempdb

Are these intended to be for any specific use?

How do I get a list of the tables that are in these databases? 

-- 
Simon Elliott    http://www.ctsn.co.uk

Relevant Pages

  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • backup after installation
    ... and the application databases? ...
    (microsoft.public.sqlserver.programming)
  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: Move Existing SQL Server to a New Server
    ... Restore master, then model, then msdb then the user ... databases during start up ... I do not want to move all user databases, ... > moving or restoring the databases - especially related to ...
    (microsoft.public.sqlserver.setup)