Drop a table

I tried to drop a table in Enterprise Manager but it won't allow me and it's
just a user table. How else can I drop it? Thanks.Can you give us the error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl..
.
>I tried to drop a table in Enterprise Manager but it won't allow me and it'
s just a user table. How
>else can I drop it? Thanks.
>
>|||I hate to be the guy who asks this, but do make sure that you refresh
the treeview on the left after you drop. This happened to me once and I
was stumped for a long time. Finally, I closed enterprise manager and
restarted. Then I realized that the table dropped, but it wasn't being
reflected in the view.
Tibor Karaszi wrote:[vbcol=seagreen]
> Can you give us the error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2M
SFTNGP03.phx.gbl...|||"Rich" <rich@.adgooroo.com> wrote in message
news:1151941402.034081.206570@.j8g2000cwa.googlegroups.com...
> I hate to be the guy who asks this, but do make sure that you refresh
> the treeview on the left after you drop. This happened to me once and I
> was stumped for a long time. Finally, I closed enterprise manager and
> restarted. Then I realized that the table dropped, but it wasn't being
> reflected in the view.
BTW, you wouldn't be the first person to do this. :-)

>
> Tibor Karaszi wrote:
news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
it's just a user table. How[vbcol=seagreen]
>

Drop a table

I tried to drop a table in Enterprise Manager but it won't allow me and it's
just a user table. How else can I drop it? Thanks.Can you give us the error message?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...
>I tried to drop a table in Enterprise Manager but it won't allow me and it's just a user table. How
>else can I drop it? Thanks.
>
>|||I hate to be the guy who asks this, but do make sure that you refresh
the treeview on the left after you drop. This happened to me once and I
was stumped for a long time. Finally, I closed enterprise manager and
restarted. Then I realized that the table dropped, but it wasn't being
reflected in the view.
Tibor Karaszi wrote:
> Can you give us the error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...
> >I tried to drop a table in Enterprise Manager but it won't allow me and it's just a user table. How
> >else can I drop it? Thanks.
> >
> >
> >
> >|||"Rich" <rich@.adgooroo.com> wrote in message
news:1151941402.034081.206570@.j8g2000cwa.googlegroups.com...
> I hate to be the guy who asks this, but do make sure that you refresh
> the treeview on the left after you drop. This happened to me once and I
> was stumped for a long time. Finally, I closed enterprise manager and
> restarted. Then I realized that the table dropped, but it wasn't being
> reflected in the view.
BTW, you wouldn't be the first person to do this. :-)
>
> Tibor Karaszi wrote:
> > Can you give us the error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "00kobebrian" <abc@.yahoo.com> wrote in message
news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...
> > >I tried to drop a table in Enterprise Manager but it won't allow me and
it's just a user table. How
> > >else can I drop it? Thanks.
> > >
> > >
> > >
> > >
>

Drop a suspect database

a sql 7.0 database goes suspect because the HD fails. Now i cant restore the database from the backup neither delete the database. How can i do it
In the fail i lose the mdf archiveRestart the sqlserver in mimum configuration mode.
Then delete the entry in the master.dbo.sysdatabases.
Restart the sqlserver.
"Rafael Araujo" <raraujoh@.hotmail.com> wrote in message
news:B1E10C04-6C75-4B0B-9958-2D38B709CF7C@.microsoft.com...
> a sql 7.0 database goes suspect because the HD fails. Now i cant restore
the database from the backup neither delete the database. How can i do it?
> In the fail i lose the mdf archive|||So you want to drop the database in order to be able to restore it from a
backup?
If so, first try DROP DATABASE from query analyzer. If that doesn't work,
try sp_dbremove.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rafael Araujo" <raraujoh@.hotmail.com> wrote in message
news:B1E10C04-6C75-4B0B-9958-2D38B709CF7C@.microsoft.com...
> a sql 7.0 database goes suspect because the HD fails. Now i cant restore
the database from the backup neither delete the database. How can i do it?
> In the fail i lose the mdf archive

Drop a Role in Report Sever

I create a new Role "TestRole"under Security/ Roles in the Report Server.
I i want to drop this Role, i get the Error that the Role does not exist ?
But the Role exist !!
Anyone can help ?

For UI operations, please post to SQL Server Tools General.

Thanks
Laurentiu

Drop a Role in Report Sever

I create a new Role "TestRole"under Security/ Roles in the Report Server.
I i want to drop this Role, i get the Error that the Role does not exist ?
But the Role exist !!
Anyone can help ?

For UI operations, please post to SQL Server Tools General.

Thanks
Laurentiu

DROP a Mirrored DB

I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
a point where I want to delete the mirrored test database. However,
when I try to drop the DB on the mirrored server I receive an error.
It won't let me delete the DB since it is in "In Recovery" mode. What
do I have to do to DROP this database? The copy on the primary server
is already removed?
Msg 3743, Level 16, State 1, Line 1
Database Mirror_Test is enabled for Database Mirroring, Database
Mirroring must be removed before dropping the database.
Found out how.
ALTER DATABASE Mirror_Test SET PARTNER OFF
shaun.steckley@.gmail.com wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
|||Hi Shaun
Check out http://msdn2.microsoft.com/en-us/library/ms180801.aspx for
instructions or look in Books Online.
John
"shaun.steckley@.gmail.com" wrote:

> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
>

DROP a Mirrored DB

I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
a point where I want to delete the mirrored test database. However,
when I try to drop the DB on the mirrored server I receive an error.
It won't let me delete the DB since it is in "In Recovery" mode. What
do I have to do to DROP this database? The copy on the primary server
is already removed?
Msg 3743, Level 16, State 1, Line 1
Database Mirror_Test is enabled for Database Mirroring, Database
Mirroring must be removed before dropping the database.Found out how.
ALTER DATABASE Mirror_Test SET PARTNER OFF
shaun.steckley@.gmail.com wrote:
> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --|||Hi Shaun
Check out http://msdn2.microsoft.com/en-us/library/ms180801.aspx for
instructions or look in Books Online.
John
"shaun.steckley@.gmail.com" wrote:

> I setup Database Mirroring for the first time on SQL 2005 SP1 and am at
> a point where I want to delete the mirrored test database. However,
> when I try to drop the DB on the mirrored server I receive an error.
> It won't let me delete the DB since it is in "In Recovery" mode. What
> do I have to do to DROP this database? The copy on the primary server
> is already removed?
> --
> Msg 3743, Level 16, State 1, Line 1
> Database Mirror_Test is enabled for Database Mirroring, Database
> Mirroring must be removed before dropping the database.
> --
>