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 |
Post New Answer View All Answers
Can you explain what is indexed view? How to create it?
What do you understand by a view? What does the with check option clause for a view do?
What are relationships and mention different types of relationships in the dbms
What is the difference between drop table and truncate table?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to start and end transact-sql statements?
What is snapshot report?
What does executeupdate return?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
How will you make an attribute not process? : sql server analysis services, ssas
Explain security with sql azure?
Which tools are available to manage SQL Azure databases and servers?
What is difference between after and before?
How to attach adventureworkslt physical files to the server?
How to make a column nullable?