How we Resize table,temp table, database and log file size
in SQL Server 2005
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 |
Post New Answer View All Answers
How to insert stored procedure result into temporary table?
What is the recovery model? List the types of recovery model available in sql server?
Define self join?
how can you check the level of fragmentation on a table? : Sql server administration
What are the different types of collation sensitivity?
What is transaction server implicit?
What are the different index configurations a table can have?
What is function of master database?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are the disadvantages of primary key and foreign key in SQL?
Explain the phases a transaction has to undergo?
Explain steps of normalization?
If the job running very slow what is the action you do
Does a server store data?