How do Ad hoc updates to system catalogs at SQL 2005
- From: "Krisnamourt via SQLMonster.com" <u21487@uwe>
- Date: Tue, 25 Sep 2007 16:43:06 GMT
Please,
somy friend have this answer so clear, I mean, any article or guide to allow
do this operation?
I have one table with problem. I can't drop it.
When I try, this message appear:
drop table T400RICF_old
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
Erro geral de rede. Verifique a documentação da rede.
Connection Broken
When I try system catalog, this message appear:
exec sp_configure 'allow updates',1
reconfigure with override
go
delete from sysindexes where id =1806785644
Server: Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.
I tried DAC connection and single use mode, but this is an instance of
failover cluster.
Any help?
Kris.
--
Message posted via http://www.sqlmonster.com
.
- Follow-Ups:
- Re: How do Ad hoc updates to system catalogs at SQL 2005
- From: Tibor Karaszi
- Re: How do Ad hoc updates to system catalogs at SQL 2005
- From: Russell Fields
- Re: How do Ad hoc updates to system catalogs at SQL 2005
- Prev by Date: Re: 32 bit SQL vs 64 bit
- Next by Date: Re: How do Ad hoc updates to system catalogs at SQL 2005
- Previous by thread: Problem attaching Northwind traders sample database in SQL Server 2005
- Next by thread: Re: How do Ad hoc updates to system catalogs at SQL 2005
- Index(es):