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
What are the advantages of user defined function?
What are data regions?
Explain how dts is used to extract, transform and consolidate data?
Why we use functions in sql server?
What are the steps to insert a table?
Describe and explain about SQL native client?
How to transfer a table from one schema to another?
Do you know what is a with(nolock)?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is implicit mode in sql server?
What are the differences between union, intersect, and minus operators?
How to delete an existing database user?
What is user-defined function?
Is it possible to create trigger on views?
What are sql azure firewall rules?
