Manipulating data in SQL2K using T-SQL2K5

  • Hi Folks,

    I would like to use t-sql in 2005 to manipulate my data in sql 2000 instead of the usual query analyzer (well kinda like the rich features in MSSMS). Would I be concerned with any data integrity issue if I run my old scripts (sql 2000) in 2005 assuming all functions used are compatible with the current version? What are the pitfalls, if there's any?


    Kindest Regards,

    SQL 2000 (Clustered)/SQL 2005

  • Good morning,

    You shouldn't run into any problems using the SQL Server Management Studio to connect to a SQL Server 2000 database.  However, your T-SQL capabilities are still limited to those available in SQL Server 2000, when connecting to the older version.  I use SSMS almost exclusively for my 2000 and 2005 SQL Server installations, with no problems.

    Hope this helps.

    Tim

  • You can also add the 2000 server as a linked server on one of your 2005 databases. This would give you the ability to use the 2005 features on the 2000 database.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Thanks all for your replies..


    Kindest Regards,

    SQL 2000 (Clustered)/SQL 2005

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply