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

Which language is supported by sql server?

968

what is the main function of a query parameter?

142

What happens if you add a new index to large table?

894

What command is used to rename the database?

952

What is the default value of an integer data type in sql server 2005?

916

Do you think BCNF is better than 2NF & 3NF? Why?

1233

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1008

Can we use custom code in ssrs?

1066

What is a fan-out query in SQL Azure?

121

Is sql server free?

878

What are the underflow and overflow behaviors on float literals?

1071

What is replace and stuff function in sql server?

1005

Can we hide the definition of a stored procedure from a use?

1150

Explain candidate key, alternate key, and composite key?

944

Is it possible to create trigger on views?

939