Hello Dearone,

SQL Server 2005 has grown old now (though it is still being used in production by many). The latest version of SQL Server is 2012.

I believe your question should be more descriptive in order to enable us to solve your query in many ways such as:

1.) You are new to Database Adminstration?

2.) You wish to become a DBA?

3.) You are a DBA and want to start working on SQL server 2005 as a result of upgradation etc etc..

Let us know..

Regards..