Viewing 4 posts - 1 through 4 (of 4 total)
Suresh B. (8/1/2011) I recommend querying sys.databases and sys.master_files
Suresh B. (8/1/2011)
Yes, actually I can read from the definition of the SP to write the select statement. But what if I cannot know the...
August 1, 2011 at 2:28 am
#1361393
The first line states that the tempdb is starting.
The second line states that the Recovery is Complete. When SQL Server starts up, it tries to recover all the databases....
September 13, 2010 at 3:23 am
#1219914
Great! Got it! Thank you very much for your help:-D
September 13, 2010 at 2:02 am
#1219879
Adiga (9/12/2010)
I have a SQL Server 2005, whose tempdb grows to 19.6G (which is very large in my case). I tried to shrink it, but failed. Although no...
September 12, 2010 at 9:09 pm
#1219817