How to know the size of any database: Syntax: sp

what is maximum size of temp db?

Question Posted / anamika

Answer Posted / anamika

How to know the size of any database:
Syntax:
sp_helpdb 'tempdb'

db_size of temp db 38.56 MB.

Is This Answer Correct ?

6 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Explain syntax for viewing, dropping and disabling triggers?

996

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1056

List down some advantages of sql stored procedure?

1014

What are views used for?

1058

please differentiate between delete and truncate?

1038

How do I find the sql server instance name?

1012

Define the one-to-one relationship while designing tables.

937

When to use Inner join & when to use subquery?

1235

What are the components of dbms?

995

Is it possible to create trigger on views?

1029

Explain nested trigger in sql?

1128

What is cursors?

1259

What are types of scd? : sql server analysis services, ssas

1077

How can we delete a table in sql server?

1019

What are horizontal and vertical scaling?

172