Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,


How many types of the database links?

0 Answers   MCN Solutions,


What is a database in ms sql server?

0 Answers  


Can we install sql server 2016 on windows 7?

0 Answers  


when inserting to a table how many rows will be effected using triggers

2 Answers  


explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,


What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,


What are the different types of backups that exist?

0 Answers   ADITI,


What is the library index called?

0 Answers  


What are sql server procedures?

0 Answers  


What is a field in a table?

0 Answers  


Explain view in sql server?

0 Answers  


Categories