Post reply

I want to change the compatibility mode of the SQL SERVER 2005

  • March 2, 2008 at 11:06 pm

    #179535

    Hi Friends,

    I am new to this blog. As i am doing a project named remote login for sql server 2005. But there is a small problem. I got the source code for my project in VS 2003 version which uses SQL Server 2000. But i need the project in VS 2005 and SQL SERVER 2005. After conversion everything works fine. But SQL server code is asking me to change the compatibility mode from 90 to 80. Please suggest me a solution to change decrement the compatibility mode.

    Thanks in Advance,

    Sowbhagya

  • March 3, 2008 at 12:45 pm

    #784629

    You can connect to your SQL server and issue the following T-SQL command:

    exec sp_dbcmptlevel mydb, 80

    go

    Make sure you have no other connections open at the time (Books Online actually recommends setting the DB to SINGLE USER, but overkill if you are the only person connecting to it anyway).


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • March 3, 2008 at 9:26 pm

    #784775

    Thank you, I will try out this solution.

  • March 12, 2008 at 8:33 am

    #788591

    You can also do this through management studio. database properties--> Options.

    Gethyn Elliswww.gethynellis.com

  • March 12, 2008 at 10:17 pm

    #788883

    Great. It works. Thank you for your answer.

  • April 25, 2008 at 10:55 am

    #807319

    Hi everyone, I know this is not really about the original post but I hope you guys can help me out. I have been searching the web in order to get some specific points about the advantages and disadvantages about changing the sql server compability mode. I know there are some reserverd words such as BACKUP, CONTAINS, CONTAINSTABLE, DENY, FREETEXT, FREETEXTTABLE, PERCENT, RESTORE, ROWGUIDCOL, TOP that I can't use, or well, at least not directly. I also know that it probably won't support some kinda indexes but besides that, is there any special advantage or disadvantage about performance? or special considerations for doing this change?

    Hope someone can help me out.

    Thanks in advance.

  • May 23, 2008 at 12:35 am

    #819497

    Hi,

    Thank you for your previous solution . Now i request you to help me with another question.

    Q: Already i have created a table using sql server, inbetween i came to know that the order of the columns in a table is not correct. So, I want to interchange the columns in a table. I know how to change the columns using design part. But i want to do this through sql query. Is it possible to interchange the columns of a table using SQL ? If yes, please provide me the solution.

    Thank you Very much..

    Sowbhagya

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

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