Viewing 2 posts - 1 through 2 (of 2 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:
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