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

How adventureworkslt tables are related?

984

How to recover from sql injection? : sql server security

1068

can SSRS reports Cache results?

155

Explain error handling in ssis?

1078

What is the purpose of object explorer and its features? : sql server management studio

1277

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1960

What are constraints?

1061

What is surrogate key? : sql server analysis services, ssas

1162

What are the types of processing and explain each? : sql server analysis services, ssas

1205

How to set database to be single_user in ms sql server?

1082

How to find Duplicate Records In table?

1076

What is postgresql server?

1060

How to name query output columns in ms sql server?

1016

Can a table have 2 foreign keys?

958

What is meant by indexing?

1088