jcrawf02 (11/13/2008)

---

So, if you build a clustered index, even if the physical order is not in the same order, if I just pull a SELECT with no order by and...

Try doing an update usage. On SQL 2000 the space use and space available metadata was sometimes inaccurate. Updateusage will fix that.

DBCC UPDATEUSAGE(< Database name > )

Updating stats won't change the scan density. That's a measure of how much extent fragmentation there is. Stats just contain the data distribution in the columns.

Try a rebuild instead of...

How do you propose doing...

Did you set it to multi-user after syncing the logins and users?

SQL won't just set a DB to single-user, Someone would have had to run a command to do so.

Post the trigger code please, the table structure a couple of example insert statements and what you want Table_2 to look like afterwards.

Continued here:

http://www.sqlservercentral.com/Forums/FindPost601206.aspx

Not sure I understand you fully.

You have a database on a SQL 2000 server that's giving errors?

Where does SQL express come in here? A different database attached to the 2005...

You originally posted in in one of the SQL 2005 forums. I asked the moderator to move it.

That doesn't sound like a login problem. It sounds like a performance problem with that procedure. It doesn't return quickly enough and the front end times out. It may be...

Use an int and make it an identity column.

Duplicate post.

No replies to this please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601923-146-1.aspx

You've got some nasty database corruption there. I don't suppose you have any idea when that started?

I'm not sure how to fix it. Let me see if I can...

Huh? Why would you want to do that?

I don't think you will be able to restore it with corruption. On the SQL 2000 server, please run the following and post the results.

DBCC CHECKDB(< Database Name > )...