dbcc dbrepair (drop database)

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

From: Colleen (Colleen_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 07:29:07 -0700

I need to drop a damaged database and BOL no longer provides the syntax for
dbcc dbrepair. Drop database doesn't work because it's being replicated.

The database is in a 'loading' state, but is not actually being restored.
When I issue drop database command it tells me it can't because it's being
replicated. This is true but I can't get rid of the publications because
it's in the 'loading' state.

Anyone know the syntax for dbcc dbrepair or how I can drop this database?

Relevant Pages

  • Re: Controlsource wont let Dlookup to enter
    ... Frustrated from entering the expression manually, using the syntax suggested ... ControlSource and clicked the Dlookup function from the list of functions. ... Is this happening in all controls on all forms in this database? ... Do you have the ClientID field bound to a control on the form? ...
    (microsoft.public.access.gettingstarted)
  • Re: Controlsource wont let Dlookup to enter
    ... Is this happening in all controls on all forms in this database? ... as such, complaining about syntax error. ... Do you have the ClientID field bound to a control on the form? ... So I put this in the ControlSource: ...
    (microsoft.public.access.gettingstarted)
  • Re: Controlsource wont let Dlookup to enter
    ... You might have to rebuild the form or you might need to decompile your database. ... as such, complaining about syntax error. ... If those were the points You've listed, it would at least let me finish the entrance in the ControlSource and then show an error in the ... Do you have the ClientID field bound to a control on the form? ...
    (microsoft.public.access.gettingstarted)
  • Re: Controlsource wont let Dlookup to enter
    ... You might have to rebuild the form or you might need to decompile your database. ... as such, complaining about syntax error. ... If those were the points You've listed, it would at least let me finish the entrance in the ControlSource and then show an error in the ... Do you have the ClientID field bound to a control on the form? ...
    (microsoft.public.access.gettingstarted)
  • Re: to optimize a select join
    ... My preferred garden variety of databases has a syntax extension ... Rows form EMP? ... Every database has its own syntax for outer joins. ... To make long story short, I hate ANSI joins, with passion. ...
    (comp.lang.php)