Dependencies of a table

Hello,

I have a table in my SQL2000 server and there's a field in this table being created by an object - with a GREEN PLUS sign (look like an APPEND query in MsAccess). How can I locate and edit/modify that (append query-like) object within my SQL 2000 - Enterpise Manager? Here's some more details:

Table: Customer

Field1: CustomerID

Field2: CustomerRegion_ID (contains the ID above & RegionID below)

Table: Region

Field: Region_ID

--

When I checked on the dependencies of the table "Customer" I saw 1 dependency and this dependency has 2 table depend on it back-to-back (Customer & Region).

I want to modify the "Field2" of the "Customer" table and I looked everywhere on my VB/stored-procedure codes but couldn't find what triggle the creation of the field. The only thing that I suspect that would be the append object with "GREEN PLUS" sign. Any help would be appreciated.

Peter.

There is no ddl trigger in sql2k. So, it would be hard to track down the point in time of the creation of the column (unless you have profiler turned on).

The best you can do is to check syscomments for the object/column name that might be used in other porcesses.

|||

it could be a trigger.

expand em to the table you need.

right click the table and then click "manage trigger"

If the dropdownlist contains something other than new

then thats the trigger thats affecting your logic