USE DataBaseName GO SELECT name,physical_name,size,max

How we Resize table,temp table, database and log file size
in SQL Server 2005

Question Posted / amrish kumar

Answer Posted / amrish kumar

USE DataBaseName
GO
SELECT name,physical_name,size,max_size
FROM sys.master_files
WHERE database_id = DB_ID('DataBaseName');
go

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are drilldown reports?

What is wide table?

522

Tell me what is the order in which the sql query is executed?

509

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

472

What is etl - extraction, transformation, and loading?

515

Which is the best place or learning center for MS SQL?????In Bangladesh?????

1584

Explain few examples of RDBMS?

605

What function does a database engine serve in the sql server?

555

what are the different types of replication you can set up in sql server? : Sql server database administration

504

How to create a simple table to test triggers in ms sql server?

499

What is the most common type of join?

516

what is the Ticketing tool used in Wipro technologies at Bangalore...???

7457

What is exporting and importing utility?

597

What method is used by the Command classes to execute SQL statements that return single values?

588

What is 2nf in normalization?

525