From SQL 2005 onwards, the query execution returns results batchwise which was available to view.

hi, check on Microsoft SQL Server 2005 Upgrade Advisor which helps you to identify the best way of upgrade.

Download using the below link.......

http://www.microsoft.com/downloads/en/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en

Regards,

Karthik

hi,there should not be any drawback but you need to change the database compatability level from 80 to 90.

Regards,

Karthik

Hi Miranda,

SQL Server 2005 was not compatible on windows vista, check below the URL for SQL Server 2005 installation requirements..

http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/RequirementsSQL2005.htm

Thanks a lot Matt..........

Pls confirm that they not even provide the PAID Support for the SQL Express Edition

Using Maintenance Plan Wizard, you can automate the backup maintenance.

hi,

My backup schedule should take automatic database backup to the system it has been hosted and i'm asking that it's possible to take those backup's in another system automatically which...