james.johnson 22741 (11/20/2012)
When I tried to modify the size of the tempdb on my system the results suggested that I was unable to specify the size of something smaller than their current size. A conservative move to make their initial size large, like suggested by the author, would require me to schedule an outage of a production system.
Modifying the size of tempdb to something larger then their current size does not require a restart, i.e. a grow operation will occur immediately upon running the ALTER DATABASE statement. From the error message you posted it sounds as if you are trying to set the value to something smaller than the current size. What were the results of the query in the article on your system and what is the ALTER DATABASE statement you are trying to run?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato