Post reply

SQL server 2005 as SQL Server 2000

  • February 27, 2007 at 12:01 pm

    #119068

    hi there

    Is it possible to use SQL server 2005 as SQL server 2000? had a chat with one of the DBA and he mentioned that setting a FLAG in SQL SERVER 2005 will do the job. Is it correct??

    Cheers

     

  • March 2, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • March 2, 2007 at 2:40 pm

    #692939

    Did you try to set complevel to 80?

  • March 4, 2007 at 12:04 pm

    #693009

    No. I have been looking around, but didn't find any suitable answer to this. will setting complevel to 80 work?? pls let me know

    Cheers

     

  • March 5, 2007 at 9:52 am

    #693160

    Changing complevel helps, but may not solve all of your issues. To know whether or not it fits your case, you need to do more tests.

  • March 5, 2007 at 1:46 pm

    #693204

    how about if I upgrade 2000 to SQL server 2005. whether my application will run on 2005. Do i need to upgrade anything else?

     

  • March 8, 2007 at 10:52 am

    #693888

    You've got to test.  We've begun the upgrade/migration process by creating a SQL 2005 test instance and migrating some databases, logins, jobs, and DTS packages.  Now we're testing our applications. 

    Microsoft has lots to say about upgrading.  See this site: http://www.microsoft.com/sql/solutions/upgrade/default.mspx

    Greg

    Greg

Viewing 7 posts - 1 through 6 (of 6 total)

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