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

Question Posted / skdeveloper0

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

More SQL Server Interview Questions

What is a rollup clause?

What is the difference between value type and reference type?

Explain what is lock escalation and what is its purpose?

Name 3 ways to get an accurate count of the number of records in a table?

How secure is sql server database?

What are the type of joins? When do we use Outer and Self joins?

what is database replication? : Sql server database administration

Can we move Resource database from one path to another? If yes,How can we?

What is the use of @@spid?

What are the disadvantages of using querystrings to send data from one page to another?

What is ms sql server reporting services?

Explain the difference between functions and stored procedures in sql server?

For more SQL Server Interview Questions Click Here