Post reply

Error in change the type of fields in SQL Server 2008

  • September 11, 2008 at 2:34 am

    #123513

    I had a SQL Server 2005. I uninstalled it and installed SQL Server 2008.

    The databases were attached normally in 2008, and now my programs work without any problem.

    Now I want to change a field data type in a table, like this: money to float, or nvarchar(50) to nvarchar(100).

    But this error occurs: 🙁

    I thought the move from 2005 to 2008 is the problem, then I made a new DB in 2008 with a table with 2 fields, for test.

    That error occurs in changing the data type of fields of the table!! :blink:

    What's the solution?

    Please help me.

    . .
    We, Iranians: "The Peaceful Nuclear Energy is our indisputable right."

  • September 11, 2008 at 2:54 am

    #870166

    I found the solution:

    Tools Menu -> Options -> Designers -> uncheck: Prevent saving changes ...

    😀

    . .
    We, Iranians: "The Peaceful Nuclear Energy is our indisputable right."

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

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