Hi,
Are you sure that it is an index? It may be an constraint.
I had a similar case when I took the drop script from an other database
(replica of the one you are working on), I also had some constraints that
have different names on both servers.
Eralper
http://www.kodyaz.com
-----Original Message-----
From: KPS Info
[mailto:mssqldba-ezmlmshield-x77692067.[Email address protected]
Sent: 30 Mart 2005 Çarşamba 04:58
To: LazyDBA Discussion
Subject: Dropping System Generated Indexes
Hi all,
I am in the process of optimizing a SQL database and there are alot of auto
generated indexes that I would like to remove. They start with _WA_Sys_...
I tried executing a
DROP INDEX AcctsRec._WA_Sys_ARAmt_75D7831F
GO
but it gives me this error:
Server: Msg 3703, Level 11, State 7, Line 1
Cannot drop the index 'AcctsRec._WA_Sys_ARAmt_75D7831F', because it does not
exist in the system catalog.
I queried the sysindexes table and the record exists for this index and when
I look at the Taskpad view for the database, the index shows up.
So, my question is, how (if possible) can I remove this index? I want to
remove all of these indexes and then see if they get regenerated as part of
my optimization process.
Thanks,
Greg
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page