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 (    ...

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, ...