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 is the report builder?

139

Mention the differences between substr and charindex in sql server.

1043

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

997

What is the boxing and unboxing concept in .net?

913

Tell me the difference between clustered and non-clustered index?

931

Why truncate is ddl command?

1058

Explain few examples of stored procedure over triggers?

1031

Write query to return all rows sql?

1049

What is the full form of ddl?

921

Explain comment on transactions?

976

what are the new features in SSRS?

134

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1005

How to provide default values to function parameters?

1130

If any stored procedure is encrypted, then can we see its definition in activity monitor?

984

How to create a login account in ms sql server to access the database engine using "create login" statements?

1137