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

What is tempdb database? : SQL Server Architecture

814

Why SQL Agent is used?

824

Explain indexed views?

761

How to backup SQL Server Reporting Services ?

122

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

763

How much space does sql server 2016 take?

749

What is #table in sql server?

767

What is the filtered index?

797

How many categories of functions based their return modes?

873

Where views are stored in sql server?

746

List all types of constraints in sql server?

706

What is difference between order by and group by?

789

How can you manage sql azure security?

Determine how to use the inserted and deleted pseudo tables?

755

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1440