|
Home > Archive > MS SQL Server > April 2005 > Re: Junior Database Developer- need help with DB stuck in Loading
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Junior Database Developer- need help with DB stuck in Loading
|
|
| bluefish 2005-04-29, 8:23 pm |
| 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...
>
>
>
| |
| Tibor Karaszi 2005-04-29, 8:23 pm |
| 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 database. 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...[color=darkred]
> 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:
>
| |
| bluefish 2005-04-29, 8:23 pm |
| Thanks!
"Tibor Karaszi" wrote:
> 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 database. 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...
>
>
>
|
|
|
|
|