what is maximum size of temp db?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

768


How do I find my localdb version?

746


How to generate create view script on an existing view?

782


What is difference between equi join and inner join?

691


What is sqlcmd?

747


What Is Rdbms?

867


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

669


1 01 101 01010

1837


How can a user-defined datatype be created?

752


Explain how to send email from sql database?

769


What is the osql utility?

750


Why should one not prefix user stored procedures with ‘sp_’?

842


What are the different sql server versions?

717


What is trigger and different types of Triggers?

864


What are the types of indexing?

869