Very Computer

'Disabling stats' really doesn't mean anything. There's nothing to be gained
by just 'turning them off', so you  might as well just drop them. It's no
problem to rebuild them, and reenabling after disabling would have to do
just as much work anyway.

HTH

--
-------------------------------------
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com

Feed Someone for Free Today!
www.thehungersite.com

Is there a way to disable statistics for a given column, and then reenable
them?
I am running SQL 7 and need to change the datatype on quite a few columns
that
are referenced by statistics.  I can always drop the statistics and then
recreate
them, but would prefer to disable them temporarily if at all possible.  Any
help
or suggestions would be appreciated.

Thanks in advance, KJ

Is there a way to disable statistics for a given column, and then reenable them?  
I am running SQL 7 and need to change the datatype on quite a few columns that
are referenced by statistics.  I can always drop the statistics and then recreate
them, but would prefer to disable them temporarily if at all possible.  Any help
or suggestions would be appreciated.

Thanks in advance, KJ