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

You could create CLR data types using Visual Studio and import them into SQL Server 2005. CLR user-defined types are like .NET objects that can be used to store data in SQL Server. Try the following links: http://msdn.microsoft.com/en-us/library/ms186366.aspx http://msdn.microsoft.com/en-us/library/ms131120.aspx

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

Here's something which Dinesh Asanka had sent the link for. What happens when SQL Server 2005 and Oracle 11g are liquidified and made into drinks, and how customers respond. Enjoy: http://www.youtube.com/watch?v=nwXHUts9uPA

SQL Server query files used by Preethiviraj Kulasingham for the 'Recovering databases using proper Backup/Restore strategy' session. Requires SQL Server 2005.

Slideshow used by Preethiviraj Kulasingham for the 'Recovering databases using proper Backup/Restore strategy' session. Includes Office 2007 PowerPoint (pptx) and Office 97-2003 PowerPoint (ppt) formats.

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

Log shipping has been a mechanism for maintaining a warm standby server for years. This article explains how to implement log shipping with SQL Server 2005. Read and see how useful it is.[Poll]