| Author |
Delete record in sysdatabases
|
|
| Davide Franzoni 2006-11-10, 7:14 pm |
| Hi,
in my SQLServer 2005 I have a DB that I can't remove it. Near the name of
the DB compare the write: "(6.5 compatible)".
I don't know what this DB is. I want to remove it but by the right button of
the mouse I can't do anything.
I deleted the .mdf and .ldf files but the DB is not removed from the DB
list. It is present in the "sysdatabases" table of "master" database but I
can't remove the record.
It is possibible to delete the record from the table "sysdatabases"?
Thank you very much.
| |
| Tracy McKibben 2006-11-10, 7:14 pm |
| Davide Franzoni wrote:
> Hi,
> in my SQLServer 2005 I have a DB that I can't remove it. Near the name of
> the DB compare the write: "(6.5 compatible)".
> I don't know what this DB is. I want to remove it but by the right button of
> the mouse I can't do anything.
> I deleted the .mdf and .ldf files but the DB is not removed from the DB
> list. It is present in the "sysdatabases" table of "master" database but I
> can't remove the record.
> It is possibible to delete the record from the table "sysdatabases"?
>
> Thank you very much.
Have you tried dropping it using the DROP DATABASE command?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
|
| sysdatabases is one of the critical table that sql server uses. it is not a
recommended to issue any DML command directly on it. So my answer is NOT TO
delete
vt
"Davide Franzoni" < DavideFranzoni@discu
ssions.microsoft.com> wrote in
message news:E4864CFC-59FB-4F52-AFD3- 3E4FB46ED5FF@microso
ft.com...
> Hi,
> in my SQLServer 2005 I have a DB that I can't remove it. Near the name of
> the DB compare the write: "(6.5 compatible)".
> I don't know what this DB is. I want to remove it but by the right button
> of
> the mouse I can't do anything.
> I deleted the .mdf and .ldf files but the DB is not removed from the DB
> list. It is present in the "sysdatabases" table of "master" database but I
> can't remove the record.
> It is possibible to delete the record from the table "sysdatabases"?
>
> Thank you very much.
| |
|
| or try
sp_detach_db
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:455491C7.8090402@realsqlguy.com...
> Davide Franzoni wrote:
>
> Have you tried dropping it using the DROP DATABASE command?
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|
|
|
|