Post reply

"Ghost" column

  • September 20, 2004 at 6:03 am

    #85382

    Hi!

    Using my trusted login (it has sa privileges) I created new column (bit, allow NULLs) for a table.  After that only me can see it and only with EM, even after reconnecting to the server.  There is no any records for this column in syscolumns table.

    Wonder what had happen!?!

    Thanks.

     

     

  • September 21, 2004 at 2:12 am

    #523748

    How is your application accessing this table, e.g. ODBC, etc.?

  • September 21, 2004 at 3:32 am

    #523758

    It is MS SQL2000 sp3.  I was using only EM.  So it is probably ODBC.

  • September 21, 2004 at 3:39 am

    #523760

    The only thing that I can think of is that the other users haven't refreshed their EM table lists, etc. since your change.

  • September 21, 2004 at 5:29 am

    #523777

    They did...  They even reopened EM, besides, there is no that column for the table in syscolumns table. 

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

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