Re: Junior Database Developer- need help with DB stuck in Loading

Thank you for the response.

Yes. I get following message.

Cannot drop the database 'Tara' because it is being used for replication. We
don't have any replicaiton set up going on at all.


Id I do sp_helpDB elmo it gives me followinf message
No permission to access database 'Tara'. I am logged on as sa.
Thank you




"Tibor Karaszi" wrote:

> Did you try DROP DATABASE from Query Analyzer?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "bluefish" < bluefish@discussions
.microsoft.com> wrote in message
> news:7FBE19B7-1C05-4636-9CCD- BC7CC92DB35D@microso
ft.com... 
>
>
>

As you deleted the files, I assume you just want to get rid of the database.
 I suggest you post to
the replication group how you remove the replication attributes for the data
base. It probably
involves running one or a few stored procedures, then you should be able to 
drop the database.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"bluefish" < bluefish@discussions
.microsoft.com> wrote in message
news:16722DA3-071A-4D70-BE1E- 20E4A1A6173B@microso
ft.com...
> Thank you for the response.
>
> Yes. I get following message.
>
> Cannot drop the database 'Tara' because it is being used for replication. 
We
> don't have any replicaiton set up going on at all.
>
>
> Id I do sp_helpDB elmo it gives me followinf message
> No permission to access database 'Tara'. I am logged on as sa.
> Thank you
>
>
>
>
> "Tibor Karaszi" wrote:
> 

Thanks!

"Tibor Karaszi" wrote:

> As you deleted the files, I assume you just want to get rid of the databas
e. I suggest you post to
> the replication group how you remove the replication attributes for the da
tabase. It probably
> involves running one or a few stored procedures, then you should be able t
o drop the database.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "bluefish" < bluefish@discussions
.microsoft.com> wrote in message
> news:16722DA3-071A-4D70-BE1E- 20E4A1A6173B@microso
ft.com... 
>
>
>