Very strange. could be fragmentation.

How much data is in the table?

Troy,

I sympathize and I'd really recommend looking at 2005, even in 8.0 mode. The architectural enhancements will help with the load, especially if you can move to 64-bit.

That aside, a...

Be sure you're not one of the connections. Don't open a query window to that database, have one to master instead.

SSMS should do fine.

If this is only a SQL server, then I would probably set Min and Max to the same value. My impression for 64bit is that you would...

SQL_oracle has my caveats for network backups. Don't do it.

If you have bandwidth issues, then you're somewhat stuck as the bandwidth is required to do the backups.

What I'd recommend is...

Did you attach the master database?

might have a naming conflict.

I'm not sure I understand.

First 3000 isn't much. I'd just run them, suck them in on your side and discard what you don't need.

Second, where is the criteria for the...

Also, don't forget there is a Cumulative Update #5 available now. Announcement going in tomorrow's newsletter.

I've dropped it on 3 laptops/desktops and one server in a VM situation and had no errors.

Rebuild the index, and it should have a clustered index on it. Likely it's just bad data.

Nice 2005 solution. It's one I wouldn't have come up with, though I think any solution would work as long as it found the duplicates. After all, it's mainly a...

First, moved this to the DTS area.

Second, do the resources on the server get beatan up? Memory low, disk/CPU high? I might try moving this to a workstation or another...

You can "guess" by looking at syslogins and check the updatedate. This can change for any number of things, but this would apply for a password change. This gives your...

I'm not a licensing expert, but what I have always learned and applied is what Eddie wrote. These are just licensing / administrative documents, not applied to the software.

FYI, if...

You set the identity when you create the table. There's no need to turn it on. The inserts will activate it.