Shouldn't be too hard. Point out to him that at...

Not a good idea if there's a lot of TempDB activity.

How busy...

😀 :hehe:

Every database should have this on in SQL 2000. In 2005 it's been replaced by page checksums which should be used instead.

It's a way for SQL to detect that a...

http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/

You can't change the frequency. The % of changes that kicks off a stats update is hardcoded. You can update stats manually using UPDATE STATISTICS.

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...