Ok.

Since I have got no answer I'm assuming this is a hard one.

One solution would be to create a test version of the database, convert it to level 90 and...

oops. My bad.

These is not such a table in regular databases. Just in mine. That's because I did this proc for personal use.

Anyway, This conditions is just to know if...

Hello Rachamim,

I had the very same problem and since I had to do it using script, the solution was to create a proc. I submited the proc on the script...

Guys,

Thank you for your answers.

Clarifying: all those queries are in a stored proc.

How do I clear the procedure cache?

What you mean "run reindex"?

About updating statics, I already run sp_updatestats. Am I supposed to do anything else?

Thanks.

Thank you for all your answers.

I still have the same problem and I am trying to defrag some indexes, but for some reason they still are fragmented.

Here are some things...

Thanks Mark.

Unfortunately it seems that the function object_definition isn't part of MSSQL-2000 - the version that I am using.

But your answer led me to a MSSQL-2000 alternative: the column...