Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Cannot access tempdb properties

    thanks the tempdb info is:

    namedb_sizeownerdbidcreatedstatuscompatibility_level

    tempdb 775.06 MBsa2Apr 4 2012Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=655, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics100

    and

    namefileidfilenamefilegroupsizemaxsizegrowthusage

    tempdev1D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdfPRIMARY194816 KBUnlimited10%data only

    templog2D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\templog.ldfNULL598848...

Viewing post 1 (of 2 total)