Post reply

SQL: Error adding new column to the existing table

  • October 5, 2012 at 7:33 am

    #268181

    Hi Guys,

    below is the error when i am trying to add a new column to the exting table. Can you please help in resolving this issue.

    Msg 6517, Level 16, State 1, Procedure sp_MSscriptcustominsproc, Line 45

    Failed to create AppDomain "mssqlsystemresource.dbo[runtime].35".

    The domain manager specified by the host could not be instantiated.

    The statement has been terminated.

    ALTER TABLE tableName

    Add ColumnX bit Not Null Default 0

    Thanks.

  • October 5, 2012 at 7:47 am

    #1546085

    Could you please provide more detailed information such as the version of your SQL Server?

  • October 5, 2012 at 8:12 am

    #1546111

    sql server 2008 sp2

  • October 5, 2012 at 10:54 am

    #1546219

    What schema does the table belong to?

  • October 5, 2012 at 2:40 pm

    #1546318

    What's the verion of .net on this box?

    Is this 32bit or 64 bit OS? How about SQL is it 32 bit or 64 bit?

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

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