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 is create statement?

959

What is row_number function?

1011

Can sql servers link to other servers like oracle?

843

What are drillthrough reports?

155

What do you understand by replication in sql server? Mention the different types of replication in sql server.

947

Can sql servers linked to other servers like oracle?

953

What is wide table?

949

How can you control the amount of free space in your index pages?

1057

What is acid mean in sql server?

1120

Why union all is faster than union?

913

Where are sql server user names and passwords stored in sql server?

1093

What Is Rdbms?

1159

How to create a trigger for insert only?

1041

What is transaction server implicit?

1012

How to test a dml trigger in ms sql server?

1045