What is the maximun sixes of .mdf in sql server 2005

Question Posted / benjamin

What is the maximun sixes of .mdf in sql server 2005..

Answer / benjamin

4GB in 2005 and 2000 2GB

Is This Answer Correct ?

3 Yes

2 No

More SQL Server Interview Questions

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

what is a self join? Explain it with an example? : Sql server database administration

Explain about system stored procedure?

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

Explain the difference between clustered and non-clustered index?

What is table-valued sub query?

How do you identify a foreign key?

Explain what is analysis service repository?

Explain the rules for designing files and file groups in sql server?

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

What are the authentication modes in sql server? How can it be changed?

For more SQL Server Interview Questions Click Here