Spaceused can get out of sync with reality, especially on SQL 2000. I've had it reporting negative space used on a table.

Run DBCC updateusage on that index and see if...

If you need to do transactional replication, then you'll have to ensure there are primary keys on all tables you want to replicate.

Please don't cross post. It wastes people's time and fragments replies. Most of he regulars here read all the forums

Disscussions to the following thread please - Index size (Performance tuning)

Also the table schemas and index definitions would help.

Renaming the log file might work. It's also quite likely to leave you with a suspect database.

Suggestions.

Set the database to simple recovery mode.

Run DBCC openTran. Note the spid that...

My take on this is that the database is responsible for the integrity of the data within it, regardless of the procedures/business layer/front end that's used.

It's often the case that...

Can you post the code in question? It may be that it can be done without a cursor at all.

You'd probably get more replies if you started a new thread in the correct forum (SQL 2000 -> Replication, seeing as you're using SQL 2000)

What about views do you want...

I was actually listening to a podcast on that last night (SQLDownUnder - Interview with Kimberley Tripp, episode 15)

The index key (the main part of the index) are limited to...

Query analyser does not work like MS Access does. See the reply to your other post on this.

Don't shrink your databases. It causes index fragmentation. See my blog post on this[/url]

To rebuild your indexes on SQL 2000, look up DBCC DBReindex in Books Online.

What 2 scenarios?

Can you explain where you're seeing performance problems please?

Rob Reid (2/5/2008)

---

Ok so having bits/tinyints in a covering index is okay then its just when you create an index on one or a couple of columns that are very...

By doesn't work, do you mean it gives an error, or doesn't get the rows you expect?

Try the following...

SELECT * FROM WO_Image WHERE EXISTS

(SELECT 1 FROM WO_Status

WHERE Status...

I'm not sure what you mean by refreshing cache.

DBCC DROPCLEANBUFFERS will clear all unmodified pages out of the data cache.

DBCC FREEPROCCACHE will remove all entries from the stored...