Database sql server2000 very slow

I have a database that had worked under msde 1.0 until reached the 2GB
of dimension and the dB was blocked. To make possible the work i had
deleted old data from some table. The database restart, but the
answers from server become very slow. So i decided to pass to Sql
Server 2000 without success. May i perform a check of this database?
if is a indexs problem there is a way to rebuild them?
Thanks in advance
Andy Wet"Andy Wet" <andy_wet@.yahoo.it> wrote in message
news:cbd71cd0.0311040107.31de9ec5@.posting.google.c om...
> I have a database that had worked under msde 1.0 until reached the 2GB
> of dimension and the dB was blocked. To make possible the work i had
> deleted old data from some table. The database restart, but the
> answers from server become very slow. So i decided to pass to Sql
> Server 2000 without success. May i perform a check of this database?
> if is a indexs problem there is a way to rebuild them?
> Thanks in advance
> Andy Wet

Can you explain what you mean by 'passing to SQL Server 2000'? Did you try
to upgrade MSDE to Standard Edition, did you backup/restore your MSDE
database on another version, etc.?

It might be worth using sp_updatestats to update the statstics in the
database, and also DBCC CHECKDB, if you think the database may be corrupted.

Simon