Re: MSDE - Master database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Robert Bravery (me_at_u.com)
Date: 10/20/04


Date: Wed, 20 Oct 2004 15:01:00 +0200

HI,

I am just testing at the moment, only installed mSDE a few days agao.
Is there no script somewhere that I can delete and recreate.
Being new to MSDE I have no idea of the purpose of this database

Thanks
Robert

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:e2P6xkktEHA.4044@TK2MSFTNGP09.phx.gbl...
> Restore the Master database. You backed it up didn't you?
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Robert Bravery" <me@u.com> wrote in message
> news:eXzllihtEHA.3860@TK2MSFTNGP09.phx.gbl...
> > HI all,
> > What is supposed to be in te master database, and how can I fix it.
> > Seems to me that I messed up and have some tables, lviews, etc,looks
like
> > from northwind database.
> > I think it happened when I tried the upsize wisard in access and made a
> > big
> > booboo
> >
> > Robert
> >
> >
>
>



Relevant Pages

  • Re: Generate SQL Script for Stored Procedures
    ... >Master database contains only the system stored ... your user database ... >and try generating the script. ... >> generate sql script is greyed out. ...
    (microsoft.public.sqlserver.security)
  • Re: Get All User Permissions
    ... Look for INFORMATION_SCHEMA views in master database. ... can be found in books online. ... using following tables(unless somebody somewhere has that script already): ... > pass in a SQL Server account name and will then report back on all ...
    (microsoft.public.sqlserver.security)
  • Re: MBS Great Plains
    ... Which database do I run this script against? ... I did try running it against the master database and when I look at my tables they still do not have the NOT FOR REPLICATION property. ... I ran RECONFIGURE. ...
    (microsoft.public.sqlserver.replication)