Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / 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

Post New Answer

More SQL Server Interview Questions

Mention the different authentication modes in sql server.

0 Answers  


what is sql server? : Sql server database administration

0 Answers  


How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,


What is the distinction amongst delete and truncate?

0 Answers  


if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  






why SQL server is more used to store database rather than Access

2 Answers  


How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  


Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,


Explain nested join?

0 Answers  


How to find the version of sql server? : sql server database administration

0 Answers  


What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  


How to update muliple row in single query?

0 Answers   MCN Solutions,






Categories