Re: sql 2000 - slow response times after creating a new database

From: Mario Splivalo (majk_at_fly.srk.fer.hr)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 18:40:14 +0000 (UTC)

On 2004-03-17, Paul Eccleston <paul.eccleston@get-rid-of-this-bell-centres.com> wrote:
> hi darren thanks for that, your simple fix sounds like a reasonable idea,
> wont sql 2000 create a new index after a period of time?, or do i have to
> force it by issuing a command?, if so what would be the command to create a
> new imdex?.
>

If you can still access your SQL7 databases, you can also choose to script
indexes on tables. In EM you can also find a 'click-me-here' to script just
the indexes.

If you can get the index script files, you should be able to apply those to
your new SQL2000 databases.

        Mike 

-- 
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@jagor.srce.hr