MS SQL 2005

Posted on 2007-07-27
Last Modified: 2010-03-19
My web application uses MS SQL 2000. I want to use MS SQL 2005. What kind of problems will this change cause?
Question by:cssc1
    LVL 75

    Accepted Solution

    Hello cssc1,

    there can have some issues with the ConnectionString. check  for details
    if you already migrate your database to 2005, then, you need to do lot of testing

    Aneesh R
    LVL 27

    Assisted Solution

    This link is from MS on upgrading to sql 2005:

    And this is the MS home page for sql 2005:

    This is an article from SQL Central on upgrading to sql 2005.  This site also has a lot of helpful resources and articles.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now