What did you try to run that cause that error?

Alter Index Rebuild?

Alter Index Reorganise?

Drop index?

Ok, so the 'first' row is the one with the lowest Area?

If so, try this.

SELECT

Area

,StateName

,CityName

,ACCOUNT_NO

,CUSTOMER_NAME

,CounterNo

,ROUTE_No

,Address

,TeleNumber

FROM

(SELECT

Area

,StateName

,CityName

,ACCOUNT_NO

,CUSTOMER_NAME

,CounterNo

,ROUTE_No

,Address

,TeleNumber

, Row_Number() OVER (PARTITION BY ACCOUNT_NO...

Fortunately the damage here is all in a nonclustered index and hence completely repairable.

Drop the index IDX_MYTABLE1_2 on MYTABLE1 and recreate it. Do not rebuild it, that may fail due...

No the issue is, if it's a permanent table...

ifila (1/12/2010)

---

I did get a couple of suggestions.

Use

CREATE PARTITION FUNCTION

or

CREATE PARTITION SCHEMA

.....but as you all know i suck at SQL, so i really dont know exactly how to use this...

J-F Bergeron (1/12/2010)

---

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the...

Can you uncheck the checkbox under publication properties?

If not (or if it doesn't change the output of DBCC opentran), please try this.

Create a transactional replication publication.

Add a single table as...

Depends. Permanent table in TempDB or #table?

Do note that creating permanent tables in TempDB is a bad idea and has a number of logistical problems since TempDB is recreated from...

Those are views in the INFORMATION_SCHEMA schema. However, afaik they are not in master at all, but are in the hidden system database (which you cannot edit).

Try

REVOKE SELECT ON INFORMATION_SCHEMA.CHECK_CONSTRAINTS...

John Rowan (1/12/2010)

---

I checked my 2005 BOL and it still shows the DROP INDEX <table_name>.<index_name> syntax. So I tried the sytrax that you've given and it works in my...

They aren't?

There should be a 'usually' there. I have ridden an...

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the time), we don't...

How about posting the objects and permissions that you can't drop. Then we can advise appropriately.

I know you don't want a lecture, but I wasn't joking when I said that...

Can you just go through all of the publications, make sure none of them are transactional, because if there is one, the advice I'm going to give will break it?

Can you check and confirm that there is absolutely no transactional replication in that database?

What does DBCC OPENTRAN return?