The syntax is : sp_helpdb 'tempdb' db_size of a tempdb is 8.50

what is maximum size of temp db?

Question Posted / senthilkumar

Answer Posted / senthilkumar

The syntax is : sp_helpdb 'tempdb'

db_size of a tempdb is 8.50 MB in sqlserver 2005.

Is This Answer Correct ?

10 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are the types of database schema? : sql server analysis services, ssas

1134

What is change tracking in sql server?

1030

List few advantages of stored procedure.

981

What is transact-sql ddl trigger?

1111

Tell me what is sql profiler?

1034

Tell me about normalization in DBMS.

998

What are the properties of the relational tables?

881

What is an inner join?

987

What is the current pricing model of SQL Azure?

104

How to create new databases with "create database" statements?

1025

What is CTE in SQL

951

How to concatenate two binary strings together?

1131

What is update locks?

893

Is it possible to replicate data from sql server to oracle? : sql server replication

1098

What are Spatial data types in SQL Server 2008

1025