Viewing 2 posts - 1 through 3 (of 3 total)
Do you want to try the following if not yet done?
ALTER DATABASE tempdb MODIFY FILE
(NAME = 'tempdev', SIZE = target_size_in_MB)
Try the following link: http://support.microsoft.com/kb/307487
Good luck!
April 8, 2008 at 10:53 am
#799897
Yor are right, but because I needed to automate the collection process and gathered info as quickly as i can, Profiler is the best tools and I find the answer...
April 8, 2008 at 10:43 am
#799894