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 delete existing triggers using "drop trigger"?
What is 4nf in normalization form?
What is CTE in SQL
Is resultset an interface?
What is the maximum length of an alert name?
How to create sub reports?
How to create view in stored procedure sql server?
Why do we use functions?
What are pessimistic lock and optimistic lock?
Can you index views?
What is database mirroring?
What are diverse clauses that form a part of sql?
What are the aggregate and scalar functions?
What does indexation mean?
How to fine-tune reports?