Hi Shangar, Unfortunately, the answer to that question is: You cannot restore a SQL Server 2005 database backup to an earlier version of SQL Server. What you can do is, Script all the objects from the SQL Server 2005 database and recreate all those objects on the SQL Server 2000 database using that script. Then use the Export Wizard to export ...

Interestingly today we found that on certain situations the following query worked better than the query I submitted.  (SQL 2000).  It is not always, but there is a difference at times.  I have not explored the reasons yet.  but a heads up so that you all can start a research on the best method SELECT * FROM (    ...

I have a Problem in My Database it's showing suspect i havetried by usng readonly mechanisum but data cannto be retreived guys is there any tools or any other redgate tools availble for me to recover data

Hi Harshana,There is no function available with SQL Server similar to ''LIMIT'' but you can get the result set as you want.Here is one the ways of limiting records with SQL Server 2000. SELECT  T.*FROM(    SELECT TOP 100 PERCENT (SELECT COUNT(*) FROM Person.Contact WHERE ContactID <= c.ContactID) AS RowNumbr, ...

Microsoft will be turning off mainstream support for SQL server 2000 for most editions of the product in April 2008: Products Released General Availability Date Mainstream Support Retired Extended Support Retired SQL Server 2000 64-bit Edition 30/11/2000 08/04/2008 09/04/2013 SQL Server 2000 Developer ...